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)

2
votes
1answer
161 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
1k 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
215 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
117 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 ...
1
vote
2answers
119 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
1k 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
64 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
275 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
113 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
350 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
308 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
335 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
2k 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
1k 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
235 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
180 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
69 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
290 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 ...
3
votes
1answer
3k 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
5k 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
165 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
598 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
79 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
133 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
136 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
452 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 ...
-2
votes
1answer
144 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
82 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
240 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
93 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
92 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
193 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
69 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
3k 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
348 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
119 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
110 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
148 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
237 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
573 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
244 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
267 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
50 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
272 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
289 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
470 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
179 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 ...