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)

1
vote
0answers
201 views

osm2pgsql - Failed to allocate space for node cache file

it's my first time trying to set up a OSM server. I have been following this tutorial: https://github.com/AnderPijoan/vectorosm (with node why i need to change how the maps are rendered for some ...
1
vote
2answers
1k views

Upgrading Postgres.app 9.1 to 9.2, getting lc_collate values do not match error

I'm upgrading a Postgres.app on my Macbook Pro (my development machine) and I'm getting an error when I run: pg_upgrade -b /Users/foo/Library/PostgreSQL/9.1/bin/ -B ...
0
votes
1answer
71 views

How to upgrade Postgresql Database Server 8.2.11-1.fc8 to 9.2

I'm new to Postgresql Database. We have an old Fedora 8 Server where we have postgresql database server 8.2.11-1.fc8, Would like to know if we can upgrade this version of postgresql database server to ...
2
votes
1answer
4k views

psql: fe_sendauth: no password supplied

I have an up and running PostgreSQL database. Now I would like to automate some operations on my database but I have a problem with the password. I am using the following bash script: #!/bin/bash ...
0
votes
1answer
367 views

How to achieve high availability PostgreSQL on windows server 2008?

I am looking for a way to get a postgresql database running with high availability on some windows 2008 server boxes. I am not an expert in windows server administration nor postgresql, so I am a bit ...
0
votes
1answer
127 views

Backing up remote Postgres database

I have a Windows 2008 Server machine with a postgres database running on it. I'd like to back it up daily and have it sent to another machine (running Ubuntu or Windows). What's the best way to set ...
0
votes
2answers
112 views

Transferring data but not structure between Postgres and MySQL

I am currently migrating a web application from one platform to a different one, and part of this migration involves moving data from a Postgres DB to a MySQL DB. The table structures will not be the ...
0
votes
2answers
158 views

Set up JDBC DataSource in LDAP

How do I create a JDBC DataSource in an OpenLDAP server? The problem is that jdbc/something is not a valid DN or RDN. But that is the format of the name that you are supposed to use for JDBC ...
1
vote
1answer
253 views

What are the options for any SQL Multi Master Master replication?

I am looking for a proper way to do Multi Master Master replication. I am currently using MySQL but open to switching to Postgres or Oracle if needed. So far the only solution I find is ...
1
vote
1answer
620 views

“Could not create IPv6 socket” postgresql standby error

I'm trying to create Postgresql 9.1 hot-standby using following steps: Configured 2 virtual linux machines. Master's ip: 10.10.10.1, Standby's ip: 10.10.10.2. Ping test passed. Restored the same db ...
20
votes
1answer
246 views

Is it possible that just one bit switches so my file shows me a letter “Q” instead of a “S”

In our application we use Hibernate and PostgreSQL to store data. In one of our database tables we have a discriminator column which says for example "TIPPSPIEL". It is a fixed string and can not be ...
0
votes
1answer
302 views

pgbouncer - failed to restart

I am logged in to a server and trying to restart pgbouncer. $ /sbin/service pgbouncer restart Stopping pgbouncer service: [FAILED] pgbouncer already running ...
2
votes
1answer
53 views

Proper postgres port forwarding on linux/ubuntu inside AWS VPC

At Amazon AWS we have VPC, where one node has public IP and others - private. Instance with public IP is something like balancer. On every node we have Ubuntu LTS. One of the private nodes is ...
0
votes
0answers
278 views

Postgresql running slow

We recently migrated our postgresql server from a heroku 400mb ram add-on to a SSD VPS with 1GB of ram and we have seen a huge performance drop. I am using ubuntu 12.06 and have increased the ...
0
votes
0answers
307 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
20 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
488 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
189 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
54 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
100 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
75 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
200 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 ...
4
votes
1answer
1k 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
75 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
572 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 ...
3
votes
1answer
859 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
312 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
370 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
7k 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
218 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 ...
3
votes
1answer
1k 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
167 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
367 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
284 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
153 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
416 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
128 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
501 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
549 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
30 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
187 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
206 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
170 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
626 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
1k 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
98 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
2answers
8k 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
317 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
75 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
924 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 ...