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
2answers
107 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
136 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 ...
0
votes
0answers
48 views

postgresql streaming replication not replicating until it reaches archive_timeout

Working primarily from this blog post I have managed to get replication working between two test servers. The master/server are supposedly set up to do streaming replication, with WAL archiving as a ...
-1
votes
2answers
531 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
264 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
83 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
95 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
58 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 ...
0
votes
0answers
39 views

Postgresql Replication slave-master writer

One thing that I don't know how to made with postgresql. I use pgsql 9.2 on Centos 6.4. I normally use system in HA and database is a critical point. Now I have 2 servers with some services and 2 ...
5
votes
3answers
234 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 ...
2
votes
1answer
735 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
2k 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
103 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
176 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
345 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
50 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
80 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
79 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
152 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
36 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
53 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
109 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
59 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
61 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
104 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
588 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
48 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 ...
1
vote
1answer
605 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
123 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
63 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
72 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
60 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
136 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 ...
0
votes
0answers
103 views

Upgraded pgbouncer 1.3.4 -> 1.5.4 and can not connect

On CentOS 6.4 Linux with the stock postgresql 8.4.13 package I have upgraded pgbouncer from version 1.3.4 to 1.5.4 and can not connect to my databases anymore. In /var/log/pgbouncer.log I see the ...
1
vote
1answer
236 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
234 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
59 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 ...
1
vote
1answer
36 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
177 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
54 views

Disable disk caches in AWS EBS for PostgreSQL?

It's my understanding that, without correctly disabling OS-level and drive-level caching, there is a chance that in case of system failure the Write-Ahead Log might not be saved correctly and in fact ...
0
votes
0answers
187 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
14 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
248 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
90 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
45 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
77 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
59 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
99 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
529 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 ...
0
votes
0answers
26 views

installing skytools on redhat4 linux

I am trying to install skytools on linux RedHat4 I have configured the installation with: ./configure --prefix=/opt/skytools-3.1.3 --with-python=/usr/local/src/skytools-3.1.3/python/ I am logged ...