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

Postgres pgpass windows - not working

DB: Postgres 9.0 Client: Windows 7 Server Windows 2008, 64bit I'm trying to connect remotely to a postgres instance for purposes of performing a pg_dump to my local machine. Everything works from my ...
0
votes
0answers
19 views

postgres sql returning "more than one row returned by a subquery used as an expression

Postgres sql is returning: more than one row returned by a subquery used as an expression The data base format is: rpt_rec_num | wksht_cd | line_num | clmn_num | itm_val_num ...
3
votes
6answers
4k views

Reloading PostgreSQL after configuration changes

I've made some changes to pg_hba.conf and I want them to take affect. I've found several places where people say that I can tell PostgreSQL to reload, but there are several different techniques ...
1
vote
1answer
16 views

Changing tablespace on table with streaming replication

I've been searching for answers for a while know but can't find any reliable source. We have 2 postgres servers that replicates using streaming replication. I now need to move some tables to a ...
3
votes
3answers
10k 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 ...
1
vote
1answer
930 views

Postgres's pg_basebackup never finishes creating backup

I'm attempting to move files to another server to setup a slave. I have a database on one Postgres Server and am attempting to create a file-based backup using pg_backup. However, it never finishes ...
0
votes
2answers
2k views

How to make a JDBC connect to Crystal Reports with Postgres

I want to create a new report using Crystal Reports. I downloaded the Postgres driver but when I want to create the connection, it shows an error "JDBC Driver not found" How can I solve it? Thanks ...
0
votes
0answers
9 views

openshift gear borks and restarts

I have a Django application on Redhat OpenShift that uses a postgresql database. I use the free plan with 1 small gear using: Python 2.7 PostgreSQL 9.2 For a certain command I get thrown out from ...
0
votes
1answer
36 views

Migrate data from postgresql 8.4 to postgresql 9.4 in 2 different servers

I have a problem with postgresql as below: I have a server CentOS 5.9 install postgresql 8.4. It is running for my production and Data Size = 300 GB. At the moment, I need migrate all data in ...
3
votes
2answers
4k views

pgAdmin cannot connect to PostgreSQL 9.1

I am trying to use pgAdmin on Windows to connect to postgresql 9.1.8 running on localhost's Ubuntu 12.04 VM. The host's port 5432 forwards to VM's port 5432. pgAdmin Error: Error connecting to the ...
-1
votes
0answers
19 views

How to configure PostgreSQL password? on a new VM

I installed my postgresql like this. sudo apt-get update sudo apt-get install postgresql postgresql-contrib and accessed it like this sudo -i -u postgres and my a gist of my pga_hba.conf # DO ...
0
votes
1answer
20 views

start postgres 9.4 server from Windows commandline [closed]

I am trying to start the postgres erver from the Windows command line but it keeps failing with the same error: 2015-04-14 10:25:19 GST LOG: could not bind IPv6 socket: No error 2015-04-14 10:25:19 ...
1
vote
2answers
2k views

issue in installing postgresql 9.3.4 on Windows server 2003 x64

Hello i really did all what i know to install the PostgreSQL 9.3.4 on my windows 2003 server x64, but i'm always stopped with this error : please see the error : http://oi57.tinypic.com/s4tb8i.jpg I ...
0
votes
1answer
17 views

Postgres protected access

I am trying to configure my Postgres instance so that only the local machine and my machine (over internet) should be able to access the database. The postgresql.conf file has parameter ...
1
vote
1answer
1k views

call multiple Sql files in a single SQL file in Postgres

How do call multiple sql files in a single sql file, in postgres For example I have aaa.sql, bbb.sql, ccc.sql. I want to execute this 3 files from xxx.sql. Can anyone suggest me how to do this.
2
votes
1answer
219 views

How to make psql completion with Windows?

There is a completion function by the psql command of Cygwin or UNIX There is not the function in psql for a Windows native. How to make psql completion with Windows? may be need readline!?
1
vote
1answer
919 views

Error in osm data data import while nominatim installation

I am doing nominatim installation on my server. I run the following command ./utils/setup.php --osm-file /usr/share/osm2pgsql/planetfile/planet-latest.osm.pbf --all to import the pbf file and Few ...
-2
votes
0answers
13 views

Postgresql Hot Standby - How to determine it's fully mirrored? [migrated]

I have set up a hot standby of a postgresql server. It all seems to be working, but I just want to be sure that I'm not missing something. In /var/lib/pgsql/9.2/data/pg_log/postgresql-Wed.log I have ...
5
votes
4answers
5k views

Postgres Remote Access

I am trying to connect to postgres remotely.I have followed this tutorial http://www.cyberciti.biz/faq/howto-fedora-linux-install-postgresql-server/ and have executed the following commands to see if ...
15
votes
8answers
13k views

What is the best filesystem for insert performance on PostgreSQL?

I'm curious if anyone out there has done any experimentation or comparisons between file systems and database performance. On Linux, I'm wondering what is the optimal file system for a postgres ...
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 ...
3
votes
1answer
1k views

pgpool2+streaming replication failover on only 2 servers?

I am trying to configure pgpool2 and postgresql 9.1 to handle failover. I currently have streaming replication running, and are using pgpool2 for read-only load balancing. I have 2 servers in my ...
0
votes
1answer
1k 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 ...
0
votes
1answer
36 views

PostgreSQL - SQLSTATE[22007]

I have a box running Debian Wheezy, It is only used to operate Airtime (Icecast, LiquidSoap) It was working fine, after loading some more data into folders and editing WATCHED FOLDERS, I am getting an ...
1
vote
1answer
1k views

Can't get postgres and kerberos (gss) working together

I am trying to get postgres and kerberos, via GSSAPI, working together. Having trouble at this point. It does not help that I am really a newbie for both technologies. I have both postgres and ...
2
votes
1answer
5k views

How to restart postgresql 8.4 on Debian Squeeze when there are no clusters defined?

How to restart postgresql 8.4 on Debian Squeeze? /etc/init.d/postgresql stop/start/restart does nothing (no output given).
0
votes
2answers
3k views

How to completly remove postgresql from Ubuntu 13.04

I've tried sudo apt-get purge postgresql sudo apt-get autoremove postgresql and sudo apt-get --purge remove postgresql But after this dpkg -l | grep postgres gives me that: pi postgresql-9.1 ...
0
votes
1answer
293 views

Database connection to postgresql refused for flask app under mod_wsgi when started by systemd

I'm having a weird problem where a flask application I am trying to run (https://github.com/pyfarm/pyfarm-master) under mod_wsgi under Apache under CentOS 7 cannot connect to a local postgresql server ...
-1
votes
1answer
52 views

Migrate OTRS database from PostgreSQL to MySQL

OTRS supports PostgreSQL and MySQL databases. I'm using PostgreSQL 9.1 for my OTRS 3.2 but I want to migrate to MySQL 5.5. Is this possible? How?
0
votes
0answers
12 views

Postgres 9.3 maximal cluster size with streaming replication [duplicate]

First, I quote from https://wiki.postgresql.org/wiki/Binary_Replication_Tutorial: In Streaming Replication, the master and the standby have special processes called the walsender and walreceiver ...
2
votes
1answer
397 views

PostgreSQL and Mongodb in production

We have a product that uses Postgres for RDBMSish data (accounts, billing, etc.) and MongoDB for each of the accounts data (which obviously can't be maintained on Postgres). In local development we ...
0
votes
0answers
15 views

Search results mismatch after postgresql update [migrated]

Today we had to update the PostgreSQL version on our database servers. Before update the version was 9.3.4 and the new one is 9.3.6. Despite the small difference in the database version and the ...
0
votes
1answer
277 views

How to install Postgres 9.3 parallel in Debian Squeeze

Debian 6 contains Postgres 9.1 installation installed from Debian backports in 5432 port How to install Postgres 9.3 also on this server. I found instructions in ...
0
votes
0answers
978 views

Issues installing postgresql with homebrew OS 10.6.8 [closed]

I'm having issues installing postgresql with homebrew on my MBP running OS 10.6.8. It finishes sudo brew install postgresql without any issues. When I try: initdb /usr/local/var/postgres ...
0
votes
1answer
47 views

Syslog-ng and Logrotate creating sparse files

We've been using syslog-ng to log our postgres logs. On top of it we run logrotate every 5 minutes which also gzips the files. Recently, we've noted that these postgres logs contain a lot of null ...
0
votes
0answers
42 views

CentOS 7 Cluster with load balancer

I'm trying to understand how clustering works in CentOS 7. I'm not a cluster expert!!! What I'm trying to do is to have three clustered services: httpd, mariadb (mysql) and postgresql. I've managed ...
21
votes
3answers
13k views

Is there a MySQL equivalent of SHOW CREATE TABLE in postgres?

Is there a MySQL equivalent of SHOW CREATE TABLE in postgres? Is this possible? If not what is the next best solution? I need the statement because I use it to create the table on an remote server ...
1
vote
1answer
57 views

The more threads the less IOPS?

I've just started trying out AWS. I have a Postgres micro instance on RDS and I'm running a crawler on a c4.large. When I have just one spider (one thread), I get about 10 write IOPS. but if two ...
1
vote
0answers
35 views

Monitoring maximum number of locks in PostgreSQL with Nagios

I'm wondering if the limit for the number of locks in PostgreSQL is fixed, or if it depends on the number of open connections. The docs say the limit is max_locks_per_transaction * (max_connections + ...
0
votes
1answer
81 views

Support for Postgres broken in HHVM 3.6.0

I keep getting Uncaught exception: Could not open extension /etc/hhvm/extensions/pgsql.so: /etc/hhvm/extensions/pgsql.so: undefined symbol: _ZN4HPHP13PDOConnection5sweepEv When I try to start up ...
0
votes
1answer
54 views

Does PostgreSQL perform on Windows as well as on Linux

This topic was brought up in 2011, and the consensus was that there were design considerations that would give PostgreSQL a leg up on Linux. It is now 2015, has that changed? If there are things that ...
0
votes
1answer
450 views

Joomla Extension Uninstall Causes 502 Bad Gateway

We have a VPS with some PHP websites hosted on our Ubuntu 12.04 LTS servers using NGINX. In a Joomla 3 site, when uninstalling an extension that errors out, the page shows an NGINX error page with a ...
27
votes
8answers
35k views

How to restart postgres on OS X?

After a reboot, postgres on my machine hasn't restarted. What command should I use in Terminal to get it going again?
0
votes
1answer
30 views

Reduce the size of main/base mysterious buildup

Using PostgreSQL 9.3. I had a long-running query updating around 8M rows. Something obviously went wrong. 2 days later I got a low disk space alert. I stopped the query and this is what I saw. ...
2
votes
4answers
1k views

Postgresql /etc/postgresql doesn't exist

I'm trying to install PostgreSQL 9.1 on a Debian Squeeze server using Backports, but after installation I don't have the /etc/postgresql folder, instead I've got a /etc/postgresql-common folder. Is ...
7
votes
4answers
11k views

Postgres error message: FATAL: Ident authentication failed for user “…”

Say you're seeing this message: FATAL: Ident authentication failed for user "..." What are the causes of this error message?
1
vote
2answers
929 views

Dovecot cannot authenticate through IMAP

I want to setup a mail server with postfix + postgresql and dovecot. At the moment i can send emails to the mail server but i cannot connect to it with my mail client because it says that the password ...
35
votes
4answers
8k views

Postgres equivalent to MySQL's \G?

Does anyone know if Postgres has a way to display query results "prettily", like how MySQL does when ending a query with \G on the command line? For instance, "select * from sometable\G" as opposed ...
0
votes
1answer
20 views

Postgres replication via different interfaces

I have one PG master server that replicates itself to one slave server. Also I would like to replicate this master to slave that is in another network. Master has 2 interfaces, and there are ...
18
votes
3answers
243 views

Risk of starting NTP on database server?

I've heard rumors of bad things happening to database and mail servers if you change the system time while they are running. However, I'm having a hard time finding any concrete information on actual ...