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
77 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 ] $ * ...
1
vote
2answers
554 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
57 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
203 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
111 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
286 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
214 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
249 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
93 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
1k 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
745 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
142 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
130 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
66 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
42 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
260 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
2k 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
3k 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
122 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
423 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
755 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
66 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
106 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
116 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
305 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
78 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
70 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
175 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
74 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
81 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
157 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
867 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
60 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
2k 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
241 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
91 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
93 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
98 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
176 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
393 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
241 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
152 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
40 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
231 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
222 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
357 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 ...