PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX ...

learn more… | top users | synonyms (1)

0
votes
1answer
372 views

Password authentication failure in PostgreSQL 9.1 from remote client

I run PostgreSQL 9.1.9 in Debian Squeeze server (using backports). The contents of pg_hba.conf file is: local all postgres trust # TYPE DATABASE ...
1
vote
2answers
699 views

How to migrate old redmine server to a new one upgrading version and changing DB engine

I am planning to migrate my Redmine (1.0.5) to a new machine. I would like to upgrade Redmine to latest version and change the database from MySQL to Postgresql with this migration. My plan A is: ...
2
votes
1answer
61 views

High shmmax value in Redhat 6.3

We are using Redhat 6.3 with 30G RAM to host our Postgres server. The (default) shmmax value is 68,719,476,736 In some forums I have read that having an shmmax value larger than the RAM causes ...
2
votes
1answer
5k views

postgresql installation : initdb data directory not empty?

I am trying to create the database and I am a newbie. When I install PostgreSQL, I gave this command sudo yum install postgresql postgresql-server and later I modified the config file sudo vim ...
0
votes
1answer
218 views

How can I solve the “split brain” issue with only 2 physical servers?

I have 2 physical servers, each will contain 2 VMs; a VM with Postgres (9.2) running, and a VM running some Python software (which will connect to the Postgres server). I'm not tied to anything in ...
0
votes
1answer
67 views

Linux server responds to postgresql querys and ssh only when pinging the server

I have a problem. My developers are using one of my local servers that is located in our office. The server is running PostgreSQL and when they try to make a query to it, it just lags and then gives ...
0
votes
1answer
460 views

Why is hash join slow in postgresql 9.1?

I transfered my DB from Postgresql 8.4 to new server with Postgresql 9.1. Size of DB is 9.9GB Data directory is situated on ssd 60GB disk. And server has 16GB RAM and 16 proccessor cores. But today ...
1
vote
0answers
162 views

segmentation fault trying to start ldap

My PDC using Samba 3.6 with LDAP (the latest version) works very fine as long as I use hdb as the backend. Nevertheless, I change the backend to sql I receive the following error while trying to ...
3
votes
1answer
1k views

Maintenance of tables: do I need to REINDEX a table after truncating and repopulating?

I have a table with about 2 million rows in it of transactional data that we use for analytics. Every week we reload this with new data, so we've been using TRUNCATE to clear it out and then inserting ...
0
votes
2answers
290 views

SSH direct stdin and stout to and from postgres client

my local can connect to remote , but it cannot connect to dbserver. remote can connect to dbserver (with psql). I want to run sql scripts from my local against the db. I am looking to a way to open ...
0
votes
1answer
69 views

Solutions for a growing Postgresql database on Amazon EC2?

I've been doing a lot of research into scaling issues on Amazon EC2, especially growing databases. I looked into how I can make the database more solid and sound (I use PostgreSQL). Many sources say ...
1
vote
0answers
60 views

How can I store the Postgresql data on the EBS Volumes and not on the Root Volume?

My PostgreSQL database is currently stored in the cloud. Normally, when creating a PostgreSQL database, all the data is stored on the root volume of the EC2 instance. How can I make sure all the ...
0
votes
1answer
84 views

How does data storage on Amazon EC2 work especially for databases?

I've been playing around with Amazon's Web Services for over a year now, however I don't quite understand how it works. When I for example select an AMI of my choice from the EC2 console and I ...
0
votes
2answers
65 views

Checking that PostgreSQL and Apache are running on Ubuntu?

I am trying to learn the best practices for checking that Apache and Postgres are running on my server. If either of them have stopped, I want to auto-restart these services. I'm using Ubuntu 12.04 ...
1
vote
2answers
102 views

PostgreSQL 8.1 out of space and stopped, data directory is empty

I used PostgreSQL 8.1 on Gentoo/Linux 2.6.14r5. My db server's disk space looks like below: db postgresql # df -l Filesystem 1K-blocks Used Available Use% Mounted on /dev/sda3 ...
-1
votes
2answers
1k views

PostgreSQL server failed to start: request for a shared memory segment exceeded your kernel's SHMMAX parameter

I increased PostgreSQL's shared buffer (among other settings) to 4096M and now PostgreSQL fails to start, giving the error message below. Should I change the kernel's SHMMAX parameter to 4096M? The ...
0
votes
1answer
154 views

SSH tunnel to a postgres database [closed]

Currently I develop on a remote dev server. I SSH into the dev server (using SSH keys) as ssh -p 22222 user@devbox.com Then from the dev server, I connect to the database over the local network ...
1
vote
2answers
199 views

Install specific version of package (postgresql) along with most recent version on gentoo

I upgraded our gentoo server, got lost in the messages and, to make the story short, I ended up removing my postgresql 9.1 BEFORE I run a pg_upgrade to 9.2.. Then I discovered that pg_upgrade requires ...
1
vote
1answer
346 views

postgres updated from 9.1 to 9.2, required database update fails

On going from postgres 9.1 to 9.2, it says that the data bases need to be upgraded so on giving the upgrade command I give and get the following $ sudo service postgresql upgrade Stopping postgresql ...
0
votes
1answer
93 views

Introduce artificial delay in streaming replication

I have set up PostgreSQL with streaming replication. It replicates very fast, in a fraction of a second. I'd like to insert a delay of 5, maybe 10, maybe 15 seconds, so that bugs related to ...
0
votes
0answers
88 views

Postgres using only 500 MB of RAM of the available 4 GB

We recently moved to running postgres server on it's own VM and tracked the memory usage of the VM. Here is what I found: That the postgres is only using 500 MB of the available memory on the VM. ...
1
vote
3answers
786 views

sudo /etc/init.d/postgresql restart (how to chose which installation?)

I have two postgresql installations: $ sudo /etc/init.d/postgresql status 9.1/main (port 5432): online 9.2/main (port 5433): online I was used to restarting the postgres database doing a: $ sudo ...
0
votes
1answer
108 views

Postgresql Database Connectivity

How secure is connecting Postgres Database using phpPgAdmin through port 80? What is the difference between accessing postgres DB through database client tools through port 5432 and acccessing it ...
6
votes
1answer
350 views

Using Postgres Basic Auth in NGINX to add query result to Proxy HTTP Header

We are trying to use the ngx_postgres module to do basic authentication through NGINX. We want to retrieve a value from the query result-pair and add it to the HTTP Header, and then proxy this to ...
1
vote
1answer
2k views

Why can't I connect to my PostgreSQL database?

I'm trying to install tentd-admin. The install fails during this step: $ DATABASE_URL=postgres://localhost/tent_server bundle exec rake db:migrate I also tried this: $ ...
1
vote
1answer
61 views

How to apt-get install a package for Ubuntu Quantal from Ubuntu Precise 12.04

On Ubuntu Precise 12.04, the package osm2pgsql is currently at 0.70.5+r25090-2ubuntu2. However I need to install a newer version 0.80 but apt-get update does not provide the newer version. Question: ...
1
vote
1answer
215 views

ZFS / ZFS send for database replication

Let's say I've got a somewhat important database but one where I don't actually care about every transaction. Before you get snarky -- it is a database storing zabbix status data, so I honestly don't ...
2
votes
2answers
776 views

Too much I/O generated by postgres stats collector process

I am using XenServer with several virtual machines having local postgres databases. Even when all applications are unused and the databases are idle, each vm causes constant storage network traffic ...
1
vote
1answer
176 views

Benefits of Heroku Postgres

Heroku Postgres seems like a nice service, that eases the pain of database management. Personally I have no experience in managing DB clusters, so that's why I like the service very much. However, I ...
-1
votes
1answer
238 views

pgpool-ii show server as down, but server is running fine

I am using postgres 9.2 with streaming replication. I have 1 master DB and 2 standby DBs, it's hosted on amazon EC2, each has it's own server. On separate server i have pgpool(3.2.3) that does load ...
0
votes
2answers
131 views

Postgresql performance enhancement

I have my setup like this: Two separate instances of the database on a clustered environment. Both instances are on dedicated servers each carries up to the standard configurations. Instance one ...
0
votes
2answers
2k views

pgAdmin cannot connect to PostgreSQL 9.1

I am trying to use pgAdmin on Windows to connect to postgresql 9.1.8 running on localhost's Ubuntu 12.04 VM. The host's port 5432 forwards to VM's port 5432. pgAdmin Error: Error connecting to the ...
1
vote
1answer
1k views

Postgresql 9.2 “invalid locale name” on Ubuntu 12.04

Today I installed Postgresql 9.2 on Ubuntu precise via apt.postgresql.org – all was relatively painless until I got stuck in a "invalid locale name: it_IT.utf8" error: root@ubuntu:/tmp# sudo -u ...
4
votes
3answers
1k views

PostgreSQL slow commit performance

We are having some problems with a PostgreSQL configuration. After some benchmarks I found out that very simple queries are taking a relatively long time, upon furter inspection it appears that the ...
0
votes
1answer
114 views

In Mac OS ,Postgres after changing data folder location . Unable to start Postgres database . it doesnt give any error

I'm trying to use Postgres on a Mac. After changing the location of the data folder, postgres didnt start. It doesnt give any error message. I've copied the data folder from another location, and ...
1
vote
1answer
714 views

PostgreSQL raw query vs “Function returns TABLE” - insane difference in performance. Why?

I work with the PostgreSQL and it is used for reporting. The way it is configured currently is as follows: There is a complex query which returns report data, like this: select Column1 as Name1, ...
1
vote
2answers
2k views

Postgres INSERT ERROR: permission denied for schema public

In Postgres I created the following table inside a db called testing: CREATE TABLE category_google_taxonomy ( category_id integer references category ON UPDATE CASCADE ON DELETE CASCADE, ...
1
vote
1answer
146 views

How to grant in Puppet a global permissions to PostgreSQL?

Official postgresql module from puppetlabs allow granting privileges on specific database. postgresql::database_grant{'grant to myuser': privilege => 'CREATE', db => ...
0
votes
0answers
75 views

how to forward pgadmin request via another box with iptables

I have two remote Linux boxes. I can access box1 directly but need to ssh into box2 from box1. What I am trying to accomplish is use iptables to forward request from pgAdmin to box2 via box1. I.e. I ...
0
votes
2answers
104 views

RAID config for write heavy postgresql 9.2 database with four disks

I have a server with 32GB ram, one intel E3-1245 and four 15k SAS disks with a BB LSI MegaRaid controller. I wan't the optimal performance for my server, which will be pretty write heavy at times, and ...
1
vote
1answer
103 views

Extracting PostgreSQL dump in a disk efficient manner

I have a 15 GB compressed PostgreSQL dump (as a pgbackup), that when extracted is closer to 60 GB. I have a cloud server with only 69 GB of free space (54 GB after the pgbackup is copied onto the ...
0
votes
1answer
521 views

Postgres's pg_basebackup never finishes creating backup

I'm attempting to move files to another server to setup a slave. I have a database on one Postgres Server and am attempting to create a file-based backup using pg_backup. However, it never finishes ...
0
votes
1answer
52 views

DB2-Express-C and Postgresql using raw harddrive as datastore

I have a system running Solaris with 2 harddrives. One holding the OS and the other unpartitioned. I was thinking about using the second as database space. My question is, if it is possible to let ...
2
votes
1answer
487 views

Postgresql unintended upgrade to 9.2.3

OK, so I'm relatively new to linux. Some months ago, I managed to set up a website using Amazon's build of CentOS, PHP and Postgres 9.1. I'd done an initdb on /pgdata which was mounted on an Amazon ...
0
votes
1answer
56 views

Postgresql does not launch [closed]

I just installed postgresql 9.1 on my ubuntu server precise I installed postgres on an ubuntu workstation before and despite following the same steps (documented) nothing works. When i do : sudo ...
0
votes
2answers
135 views

PostgreSQL, automate REINDEX, Windows environment

I have a couple of PostgreSQL tables (9.1) which are inserted to / deleted from often. Over time they suffer from index bloating even though the autovacuum is configured and runs regularly. I'm ...
-1
votes
1answer
1k views

Why is Postgres not starting? [closed]

Somehow my Postgres is not anymore starting: # psql psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket ...
0
votes
0answers
133 views

Postgres segfault on Ubuntu 12.04 64

i have a unbelivable problem: Ubuntu server 12.04 64 bit running on Wmware Infrastructure, postgres 9.2 and django connecting via psycopg. Randomly postgres crashes with segfault, si i restart it an ...
0
votes
2answers
640 views

What is a typical Compression Ratio for an SQL Database backup file? [closed]

One of my clients want us to give a safe estimate of how much disk space does a compressed SQL backup file take. They need to size their server hard disks accordingly. We can rouhgly estimate the ...
2
votes
0answers
209 views

Postgres roles best practice implementation

Folks, I could use your help making my Postgres user access control design better and more aligned with best practices. I'm helping roll out a small production Postgres server but I am not a DB ...