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
0answers
224 views

Samba username doesn't work once I join a Windows XP machine to my domain

I have set up a PDC using Samba, LDAP and Postgresql. I have successfully added all the necessari entries to my database and can also see all the necessary entreis in LDAP. I can also successfully ...
0
votes
1answer
18 views

how can I change the logfile permssions for postgresql 8.4?

I see that there is a log_file_mode that was introduced in either 9.0 or 9.1, but it is not available for PG 8.4. How to people manage to give access to the logfiles to users other than the postgres ...
0
votes
0answers
362 views

How do I install the Postgresql PLDebugger server extension on Ubuntu 12.04 server?

I have installed the build tools and the postgresql devel packages with: sudo apt-get update & sudo apt -get install build-essential zlib1g-dev libreadline-dev flex bison libssl-dev git-core ...
0
votes
1answer
133 views

change socket to other then default in phpPgAdmin

I need to change the socket phpPgAdmin connects to in its config. // Hostname or IP address for server. Use '' for UNIX domain socket. // use 'localhost' for TCP/IP connection on this computer ...
0
votes
1answer
47 views

Sed issue with numbers exceeding 9

May be my problem is kinda obvious for you but I really need to get a solution. I need to generate a file.sql file from a file.csv, so I use this command : cat file.csv |sed "s/\(.*\),\(.*\)/insert ...
0
votes
1answer
88 views

Where to look for PostgreSQL sock file on Centos 6.4?

I installed postgresql9.1 into my Centos 6.4. I can do psql template (as root) to open the database console but cannot use Rails rake db:create to create the database: FATAL: Ident authentication ...
0
votes
2answers
65 views

Graph arbitrary data on the command line

I'm currently debugging an issue where I see a large number of threads in my application hanging on to a database connection even though they are asleep, often the threads sleep for a significant ...
0
votes
0answers
157 views

postgres server won't start

I get this error when I try to start postgresql: Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 235. Line 235 in /usr/bin/pg_ctlcluster last if ...
3
votes
1answer
877 views

postgres 9.1 master-master setup using Bucardo

is anyone aware of any comprehensive tutorials for setting up 2 postgres 9.1 databases in master-master configuration? What "add-ons" are required (for example is Bucardo still a necessity?). I have ...
-1
votes
1answer
73 views

Stablist / easiest to maintain free OS to run SAMBA 4, PostgreSQL, mod_perl2 on? [closed]

This is just for a 20-client network of XP Pro machines: a file/print share server, possibly a domain controller unless I can get by without it, and a db and intranet app host. I need to be able to ...
0
votes
2answers
263 views

Difference of postgreSQL's “trust” and “ident”?

In postgreSQL's /var/lib/pgsql/data/pg_hba.conf trust and ident can be set as method e.g. like so. # TYPE DATABASE USER CIDR-ADDRESS METHOD local all postgres ...
2
votes
1answer
537 views

OOM despite available memory (cache)

We've been running into the OOM killer despite nearly half of our memory being used for the FS cache. We've been logging memory stats once per minute (as reported by top), but there seems to be ...
4
votes
2answers
265 views

Why is domU faster than dom0 on IO?

I have installed debian 7 on a physical machine. This is the configuration of the machine: 3 hard drives using RAID 5 Strip element size: 1M Read policy: Adaptive read ahead Write policy: Write ...
-1
votes
1answer
218 views

authentication failed starting psql

After installing postgres, I tried to start psql on my VPS and got an authentication failure ~$ psql Password: psql: FATAL: password authentication failed for user "michael" I went back to my ...
2
votes
2answers
5k views

installing postgres on ubuntu package not available

I'm setting up a VPS with Ruby and Postgres. On my local machine, I have postgresql 9.2.3 (client and server) installed and therefore wanted to install the same on my VPS. Following the instructions ...
0
votes
1answer
151 views

Postgresql archive_command on a cascading standby server

I've found out that archive_command is only run by postgresql on a master. If I'm running a cascading replication like: Master -> Slave1 -> Slave2 and want to archive WAL segments on Slave1, the ...
2
votes
1answer
865 views

How to configure rsyslog to log into PostgreSQL without too much latency?

I'm trying to configure RSyslog on a Debian machine to log everythingo into PostgreSQL, while also logging as usual on disk. I'm using a pretty stock Debian configuration and I activated the related ...
0
votes
0answers
125 views

Cannot connect to Postgres from remote address

I cannot connect from my machine to a server running Postgres. I think I've configured it all correctly. No firewall are present on the server. I'm running Postgres 9.1.9 on Ubuntu 12.04 LTS This is ...
0
votes
1answer
279 views

Understanding postgreSQL's indent, md5, password in pg_hba.conf

If I have the following in my pg_hba.conf # TYPE DATABASE USER CIDR-ADDRESS METHOD local all all trust local all all ...
3
votes
3answers
252 views

If I `sudo reboot` my Ubuntu 12.04.2 server with Postgres running, can I lose data?

I've been wondering for the longest time if a sudo reboot with a running Postgres (namely, 9.2.4) server can (or definitely will) lead to data loss or other problems (e.g., inability to start again ...
2
votes
1answer
119 views

Building the necessary dependencies when apt-get installing on Ubuntu

I've got an Ubuntu 12.04.2 server and I want to install Postgres 9.2.4. If I wanted to build all dependencies, I couldn't use apt-get build-dep (at least without some finagling) because only 9.1 is ...
1
vote
2answers
276 views

Using Puppet to install, initdb and start Postgres database

We are trying to write a Puppet to provision the Virtual Machine. One of the tasks is to install and populate Postgres database with data. We can decompose this task into a few smaller tasks: ...
0
votes
1answer
104 views

Why won't Postgres start after stopping it?

Postgres was running just fine (I have created a database using template0). Then, I used: $ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data stop --mode=smart to stop Postgres and it stopped ...
1
vote
2answers
382 views

Dependency issues installing postgresql

Here is the steps I've followed to install postgresql on Debian server: add backports deb http://backports.debian.org/debian-backports squeeze-backports main contrib non-free to ...
-1
votes
2answers
392 views

Postgresql pgdump script on RHEL5: “failed: fe_sendauth: no password supplieddatabase ”

What I'm trying to accomplish is having a pg_dump script run as a cron job. Right now I'm just trying to get the script to run by invoking it myself at the command line. I've searched the postgresql ...
0
votes
1answer
29 views

Running PostgreSQL commands in other language

Is there a way to force PostgreSQL commands (pg_ctl, postgres, initdb, etc.) to run in English and not honor the system locale? Thank you!
0
votes
1answer
146 views

Postgres SQL Installation

I installed Postgres SQL as the root user and created the user Database for it. I am trying to access the database from a non-root account through a Linux Redhat system. The software I installed ...
0
votes
1answer
154 views

Postgresql replication lag EU/US

I've a Postgres 9.2.1 server master (geolocalized in EU) and 2 slave replica (one in EU and one in US). The EU slave is used also for read queries, the US only for failover. Is it possible to have a ...
2
votes
2answers
131 views

PostgreSQL WAL archiving on secondary server

I'm using PostgreSQL 9.1 with streaming replication for failover and WAL for archiving. If I use the archive_command configuration directive on my standby server it will always fail (because the WAL ...
0
votes
1answer
458 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
854 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
72 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
246 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
68 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
521 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
181 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
2k 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
336 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
79 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
82 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
104 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
70 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
113 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
175 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
238 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
396 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
104 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
95 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. ...