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
1k views

Can't install PG rubygem on Centos

I am attempting to run gem install pg on my Centos VPS but am getting Building native extensions. This could take a while... ERROR: Error installing pg: ERROR: Failed to build gem native ...
3
votes
1answer
2k views

Change and initialize Postgresql 9.3 default data and log directories on Ubuntu 12.04 LTS

On Azure with Ubuntu 12.04 LTS image, we're trying to change Postgres 9.3 default data and log file paths and also initialize them for the first time on a secondary drive /mnt/pgdata. We've starting ...
2
votes
1answer
259 views

What is “backup mode” in postgresql?

I am in the process of setting up a standby server for a PostgreSQL 9.3 install. I was looking to use pg_basebackup to get the initial starting point for the standby server. However, the documentation ...
1
vote
1answer
2k views

how to install pg_archivecleanup for postgresql 9.3 on Ubuntu

I am trying to get streaming replication working with postgresql 9.3 on Ubuntu 13.04 (Raring Ringtail). I installed postgresql on master and slave by doing: apt-get install postgresql I believe ...
0
votes
1answer
337 views

pg_dump fails, no space left, need to delete partial backup file to free space

Easy points. On my mac, postgres.app 9.2, I ran "pg_dump pdbt > pdbt.sql". It used up all my space and then failed with the error below. Now I want to free up the space taken up by "pdbt.sql" but I ...
1
vote
1answer
161 views

Invalid byte sequence for character encoding 0x00 after upgrading from 8.3 to 8.4

I'm trying to upgrade a database from PostgreSql 8.3 to 8.4, I backed up the data from 8.3 and restored from 8.4 without issues, but, when I try to use the same program that is working perfectly ...
2
votes
2answers
302 views

How to disable 1 version of PostgreSQL server without uninstalling it

I have installed PostgreSQL 9.1 and 9.2 on my Ubuntu machine. The postgresql service starts both versions: $ sudo service postgresql start $ * Starting PostgreSQL 9.1 database server [ OK ] $ * ...
3
votes
2answers
2k views

Why doesn't sudo know where psql is?

The problem The CKAN installation documentation shows you how to list the installed PostgreSQL databases. The command looks like this: sudo -u postgres psql -l When I try that in my shell, I get ...
0
votes
1answer
67 views

Postgres - Ship WAL logs from many servers to one

I have a number of independent postgres servers in my (recently inherited) environment and I am planning on backing them up via WAL shipping. I'd like to make one backup server that contains a copy ...
0
votes
1answer
369 views

Restoring Postgres 8.3 dump in 8.4

I need to move a PostgreSql database from 8.3 Windows to 8.4 running on Linux (Ubuntu Server 12.04). The restore aparently is ok, but when I try to show data in my program I get an error saying that ...
1
vote
1answer
115 views

Best PostgreSQL HA strategy for 99% read scenario?

I'm in the process of building out a new PostgreSQL (9.3) environment in which traffic hovers around 99% read. We'll have 2 very powerful machines, connected via 1Gb ethernet. With the multitude of ...
-1
votes
1answer
413 views

Unable to login in phpPgAdmin

I am trying to login to phpPgAdmin from a remote client. I've created the user root, but when I login phpPgAdmin returns an error message saying "Unable to login" When I check the log it says: ...
1
vote
2answers
376 views

Upgrade Postgresql database from 9.1 to 9.2 AND 32-bit to 64-bit

As part of a server upgrade we are going from 32-bit Linux to 64-bit Linux (Gentoo if it makes a difference) and Postgresql 9.1 to 9.2. I'm having a heck of a time upgrading the database with ...
0
votes
2answers
422 views

PowerDNS pgSQL Configure Different Schema

I've been using PowerDNS for a few years now and finally decided to switch over to pgSQL instead of mySQL. I've been researching this question but I haven't found anything solid so I'm assuming it's ...
-1
votes
2answers
4k views

How to build & install pgsql PHP extension manually on Ubuntu

I've searched high and low and haven't found anything. Perhaps I don't know what to search for. Environment is Ubuntu Lucid (10.4) with PHP 5.2.4 & PostgreSQL 9.2. PHP is "held" at 5.2.4 with ...
0
votes
1answer
2k views

Running out of memory, or running out of disk space?

I'm running a database loading process (osm2pgsql) which is failing: Processing: Node(17404k 148.8k/s) Way(1351k 6.38k/s) Relation(9520 29.94/s)way_done failed: ERROR: could not extend file ...
2
votes
1answer
365 views

Why a PGSQL graphical client can connect through SSH Tunnel and not me?

I have a PostgreSQL server which allow only local connexion. I'm using "Navicat for PostgreSQL Lite" to do some admin operations. In this client, I configured a SSH Tunnel to my server. Everything ...
0
votes
1answer
245 views

Postgres fails to start, pg_clog fails

Recently one of the machines running Postgres ran out of disk space. After deleting some trashes (not related in any way to postgres!) I've rebooted the system, and - after that - Postgres refuses to ...
1
vote
0answers
74 views

PostgreSQL replication lag Ubuntu 11.10/12.04

I've a PostgreSQL cluster running on Amazon AWS EC2 instances with streaming replication and "hot standby" option enabled. I'm now gradually upgrading it from Ubuntu 11.10 to Ubuntu 12.04 LTS and I've ...
5
votes
3answers
331 views

Correct way to handle security threats to web server on budget [closed]

During our annual security review I was reminded of an incident earlier this year where we received a threat to our organizations web server. It was over a organization policy and threatened to DDoS ...
5
votes
1answer
4k views

How to ensure a service is running, using Chef?

I am in a situation where Chef might start a service (postgres) but it might subsequently be stopped out-of-band. I want a subsequent Chef run to cause the service to be running. I have tried this: ...
1
vote
1answer
6k views

How do I fix issue causing “incomplete startup packet” log message trying to implement replication in Postgresql?

I've got two cloud servers running Ubuntu 13.04 and PostgreSQL 9.2. I've primarily used this blog post to aid me in setting things up. However, to do the initial database dump to the slave I'm using ...
0
votes
1answer
217 views

TOLVEN installation: Test Database and LDAP Connections After ConfigPhase1

I am trying to install tolven, and following the manual http://wiki.tolven.org/index.php/Installation_Guide My linux system info is as follows: root@localhost:/> cat /etc/issue **CentOS release ...
6
votes
2answers
849 views

Why is Postgres sitting 95% idle, with no file I/O?

I have a TileMill/PostGIS stack running on an 8 core Ubuntu 12.04 VM on an OpenStack cloud. It's a rebuild of a very similar system which was running nicely on very similar hardware (same cloud, but ...
0
votes
1answer
1k views

How do I grant select, insert privileges in Postgres on Cygwin?

How do I grant permissions in Postgres? I followed the documentation, however it is not working. $ psql tmadev psql (9.2.4) Type "help" for help. tmadev=# grant all privileges on database tmadev to ...
0
votes
1answer
102 views

How do I upgrade Postgres database in Cygwin?

I updated some Cygwin packages and now I can't start Postgres: $ /usr/sbin/postmaster FATAL: database files are incompatible with server DETAIL: The data directory was initialized by PostgreSQL ...
-3
votes
1answer
174 views

Can postgres go faster? [closed]

My question is simply: have i missed any configuration settings that might make postgres achieve better read throughput? Background I'm modeling a very simple twitter program. My schema has only 3 ...
0
votes
1answer
158 views

Optimize nginx/php-fpm/postrgresql [duplicate]

I've got: a CPU E5-2407 (quadcore Xeon 2.2GHz) 16GB of memory DDR3 RAID1 Intel520 SSD 240GB My homemade applications are using a permanent PG connection on 7 pages (one called by customers as API, ...
1
vote
0answers
768 views

postgres not starting after reboot on ubuntu

I'm not familiar with ubuntu (raring), so could someone help me please: I'm using postgresql 9.1 from apt. It installed the appropriate init script in /etc/init.d/postgresql. I can start the server ...
-1
votes
1answer
248 views

postgresql how to cd main folder [closed]

The right way to run psql is sudo -u postgres psql However, what is the right way to open the dir with postgresql files? bom@ubuntu:/var/lib/postgresql/9.1$ cd main -bash: cd: main: ...
0
votes
0answers
103 views

not sure how to handle postgresql connections

I've done a fresh install of ubuntu and am setting up PostgreSQL I'm perplexed by something: In order for my commandline user to access PostgreSQL, I need to export an environment variable export ...
0
votes
0answers
311 views

Password data is not valid for scheme SHA512: Input length isn't valid (24 instead of 64)

I am setting up dovecot with pgsql. I have setup the MTA and can receive mail correctly with the mailboxes setup in the database, but when i login via a mail client to dovecot I get in my maillog: ...
0
votes
1answer
123 views

pg_basebackup exclude one table

We perform (Point in time recovery) PITR backup on postgresql. We use pg_basebackup for daily snapshots and recovery_command for incremental backup. So, we have a big table with logs in the ...
0
votes
1answer
110 views

Installed JDBC drivers into Solr

I am running Solr4 on Jetty9 and I am trying to include the JDBC drivers for both MySQL and PostgreSQL. I'm a little confused about how I do this. I believe these to be the two files I need: ...
1
vote
0answers
232 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 ...
2
votes
2answers
2k 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
82 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 ...
4
votes
1answer
5k 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
463 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
139 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
136 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
189 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
295 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
841 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
256 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
422 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
61 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
310 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
351 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
25 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 ...