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
1answer
20 views

PostgreSQL installation under debian

I'm trying to install PostgreSQL server on a server running debian8. I installed the package postgresql-9.5 with apt, but it seems like there are missing programs. I tried to create a cluster but ...
1
vote
1answer
15 views

Unattended install of PostgreSQL 9.5 on Windows, modifying config files

I'd like to perform an unattended installation of PostgreSQL 9.5 on a number of Windows 7 machines, ideally by assigning an MSI via Group Policy. There seems to be no MSI file, but the EnterpriseDB ...
0
votes
1answer
16 views

PostgreSQL configs are ignored

I have a custom postgresql build, that shows the following output on pg_config BINDIR = /var/buildout.webstacks.xwiki/bin DOCDIR = /var/buildout.webstacks.xwiki/share/doc/postgresql HTMLDIR = ...
1
vote
1answer
21 views

PostgreSQL 9.5 via puppet module fails to install on Ubuntu Trusty

Attempting to use Puppet to install PostgreSQL 9.5 on an Ubuntu Trusty, using all the documentation I could find, with the following simple class structure: class { 'postgresql::globals': ...
0
votes
0answers
16 views

Can one check available cores at runtime on postgres?

TL; DR: Is there anyway to query a postgres instance for how many cores it has available for processing? Postgres has a good reputation with respect to parallelizing multiple queries efficiently ...
1
vote
0answers
30 views
+100

Postgresql streaming replication with restore_command for archived WAL files

I have a primary server that archives (and gzips) WAL files into /wal/archive/. At the moment, I'm attempting to set up a hot standby with streaming replication from a base backup. When starting up ...
0
votes
0answers
18 views

What Heroku setup would support 3-5 Million visitors per hour [duplicate]

A post on the Reddit front page will gather as many as 30 million to 50 million page views. All of that within 24 hours, and perhaps only within 10 to 12 hours. So, there could be 3 to 5 million ...
1
vote
2answers
19 views

PostgreSQL can't authenticate from localhost, but only from remote

I have a server with postgreSQL running. A few days ago I set it up so that I can access the database remotely from my home PC and that worked (based on this guide: ...
0
votes
2answers
46 views

Mail Server Can't Receive Email But Can Send Email - Postfix, Dovecot, Postgresql

I have server where I want to set up a mail server to let me receive and send email from my domain. I'm currently having a problem where while I am can not receive mails. Sending emails works perfect. ...
0
votes
2answers
36 views

How to connect postgresql with LDAP user?

I have a server with postgresql-9.4 fresh install and I have another server with LDAP already installed. I want to connect postgresql with LDAP user that already exists. What's the basic ...
-1
votes
0answers
23 views

Restoring postgresql 9.4 crashed database [migrated]

Can anyone help me to restore my crashed database. Is there a way to use pg_resetxlog. I read a number of documentations telling about it but i'm always seeing the same log when i restart my ...
0
votes
1answer
45 views

postgresql-9.5 on CentOS 7 won't start on boot (PGDATA on mount point)

I am trying to get postgresql-9.5 to start on boot on CentOS 7. I've followed the installation and startup steps here https://wiki.postgresql.org/wiki/YUM_Installation And have tried some additional ...
0
votes
0answers
15 views

Dovecot - postgresql DB lookup

I am scratching my head when configuring Thunderbird with my Postfix/dovecot server. The email client connect to the server but will not accept my username/password. But looking at dovecot log, user ...
0
votes
1answer
39 views

Let php PDO work with newest version of PostgreSQL (Debian/Ubuntu)

I installed PostgreSQL and the php PDO driver on my 14.04 Ubuntu like this: sudo apt-get install postgresql postgresql-contrib sudo apt-get install php5-pgsql Which installed PostgreSQL 9.3 and ...
1
vote
2answers
33 views

Does zfs recordsize impact compressratio

We host a postgresql95 OLAP database on zfs with lz4 compression turned on. As recommended we tuned the zfs recordsize to 8KB since this is postgres block size. The write ahead log is on it's own ...
1
vote
1answer
56 views

/var/run/postgresql missing after reboot

I have Centos7 machine set up and I'm having problems with postgres not starting after reboot. Even when I try to run the service manually I'm getting UTC FATAL: could not create lock file ...
2
votes
1answer
18 views

postgres solaris smf service reports status online before it can listen for connections

I have an SMF service (Naviserver web server) that depends on postgres to be up and running (i.e. accepting connections) before it should start. Postgres reports it's status as "online" well before it ...
1
vote
0answers
44 views

Postgresql with data on distributed file system

I am curious if somebody is actually running postgresql in production with on some form of distributed file system - glusterfs preferably, or anything. Now i have mesos/marathon running for hosting ...
1
vote
0answers
27 views

PgPool2 alternative for load balancing in Postgresql cluster

I'm using PgBouncer for connection pooling, native psql replication in master-slave mode and PgPool2 for load balancing. After a few (many) attempts to get PgPool2 playing nice I give up. To many ...
0
votes
1answer
31 views

Salt: Read property file into Postgres database

I have a Salt script that, among other things, initializes a Postgres database. After initializing the database, I want to read some properties from a file, and do an INSERT (into a configuration ...
0
votes
0answers
40 views

Running an init.d startup script as a non-root user (PostgreSQL-related)

I am currently installing PostgreSQL from source on a RHEL6 system. I have generally been following the official documentation for guidance ...
0
votes
0answers
21 views

Why in my index in a cold situation that slow?

We have a table CREATE TABLE mytable ( ... myfield bigint, ... ) and an index CREATE INDEX fk_fk18edb1cf49a32f88_idx ON mytable USING btree (myfield); and a simple query SELECT count(*) ...
0
votes
0answers
12 views

Force files to stay in dentries und inodes cache on SuSe

We have some sql queries which are rarely executed. When running them first time after a while they take about 2 minutes, a second call takes only 800ms. I found out when i restart postgres the ...
-3
votes
1answer
38 views

Ubuntu: Postgresql not using ram

I have a 4GB 2 core Ubuntu droplet that doesn't seem to properly make use of the RAM and CPU. I have tried to optimize the settings in postgresql.conf to match the instance with (based on pgtune): ...
1
vote
1answer
9 views

How to store a login path for psql?

I have a postgres instance on Amazon RDS and I want to store the login path so I don't have to remember the host name/username/password to log in each time. In mysql I can simply create a login_path. ...
0
votes
0answers
24 views

Postfix and PostgreSQL: How to make same aliases work for different domains?

I've currently three domains. I want to setup (mostly) the same aliases for every domain and retrieve the mails on Thunderbird. It already works to send/receive mails for contact@domain1.com, ...
1
vote
1answer
31 views

Correct iptables rules to allow linking of docker containers

I have two Docker containers on a Debian 8.3 node. One is the official postgres image, one is a basic phoenix / elixir app. I'm linking both with a docker stack file. But phoenix is not able to ...
0
votes
1answer
53 views

Postgres server not starting on drbd + pacemaker

I am trying to bring up the postgres server over ubuntu 14.04 with drbd and fiesystem. Service state as below: Last updated: Mon Mar 14 01:16:45 2016 Last change: Mon Mar 14 01:05:53 2016 via ...
0
votes
1answer
22 views

postgresql produce i/o load if nobody is connected

hello i have a postgresql-server in a docker container. nobody is connected to this server but the server produce i/o loads. the question is why? stats_temp_directory is set to the /tmp dir total ...
0
votes
1answer
34 views

postgresql - How to deamonize postgres server process for ordinary user

I'm trying to set up a PostgreSQL cluster in my home directory on Debian. EDIT: There are a couple of reasons why I think this a good idea: I don't use Postgres frequently so I don't currently have ...
0
votes
0answers
31 views

postgresql in lxc container doesn't start after reboot

Debian stable (Jessie) I have few containers - in one container there is postgresql. I want to start it first (I hope that my config does it). After reboot all containers starts, but i can't log in ...
0
votes
0answers
18 views

How to export particular table schema and data using ora2pg migration?

I'm using ora2pg migration tool for migrate table schema and data from ORACLE database to Postgres Database. Using the following query, I can export the entire schema and data from the ORACLE ...
1
vote
1answer
22 views

Why should postgresql.conf not be in the same dir as recovery.conf?

Apparently, I should put postgresql.conf in a separate directory, according to this: # Note that recovery.conf must be in $PGDATA directory. # It should NOT be located in the same directory as ...
0
votes
0answers
9 views

Server requirement RAM and CPU for postgresql [duplicate]

There is no questions regarding this and postgresql. I know this is hard to answer, but I just search for rules of thumb, best practice or just your experience. My postgresql server is both ...
-2
votes
1answer
30 views

Error when I run “bucardo add database mybd”

This is the message error: install_driver(Pg) failed: Can't locate DBD/Pg.pm in @INC (@INC contains: /usr/local/lib/perl5 /usr/local/share/perl5 /usr/lib/perl5/vendor_perl ...
0
votes
1answer
25 views

postgresql on iscsi that refuses to start … on server's boot - Redhat 7.1

I installed a postgresql database on Redhat 7.1 and I decided to move the database on an ISCSI device (LUN) inside a logical volume, mounted at starting of the machine (xfs formatted). The mounting ...
0
votes
0answers
57 views

Docker postgres database errors

I started using Docker PostgreSQL 9.5. Im using Docker and docker-composer to start my 2 containers: I followed the following link for reference: ...
0
votes
1answer
27 views

Redis and Postgresql on same machine: vm.overcommit_memory=?

In the Redis documentation it clearly states that vm.overcommit_memory should be set to 1 to ensure background saving newer fails: http://redis.io/topics/faq HOWEVER In postgresql documentation it ...
0
votes
0answers
197 views

Sending PostGreSQL log data to Logstash using Packetbeat

I am trying to configure sending pgsql log data to elasticsearch. The architecture is like this: packetbeat -> logstash -> elasticsearch. After running packetbeat, logstash log says: :message "Beats ...
1
vote
1answer
29 views

postgresql installation failed with apt-get

I'm running on an AWS Ubuntu image. In an attempt to set up my machine, I played around with apt-get to add and remove PostgreSql and some of its modules. Now, when I run sudo apt-get install ...
0
votes
2answers
93 views

Unable to access postgres remotely from Azure VM

I'm trying to access a postgres database remotely and I can't for the life of me get it to work. I've installed a Gen 2 linux VM in Azure with Ubuntu 14.04 and installed postgres. SSH works ...
0
votes
1answer
25 views

XA Connection for PostgreSQL in Weblogic

PostgreSQL supports XA Transactions. I need to use them in my WebLogic 12.1.3.0.0. When I try to create a new generic datasource in the admin console for this I can select 'PostgreSQL' but in the ...
2
votes
1answer
75 views

Connection to postgresql hangs over SSH tunnel on OSX

Trying to connect to a remote PG server on OSX but it keeps timing out. First, I set up the tunnel: ssh -L 5433:serverip:5432 user@serverip Then in a separate terminal I attempt to connect to PG: ...
0
votes
1answer
33 views

Setting up Postgres hot standby in AWS

We have a Posrgres 9.5 database running on an EC2 in AWS and we're trying to set up a hot standby. The server has around 3TB of data, so backing up is not a quick task. I initially tried to create a ...
0
votes
1answer
14 views

Increase in “table lookup” on old Postfix/PostgreSQL installation

The box is still running PostgreSQL 8.1 and this started to increase a few weeks ago. It is only happening while the server is a bit busy. fatal: ...
0
votes
1answer
33 views

How to check memory consuming process on AWS RDS postgressql

I am using AWS RDS postgresql with instance type db.t2.medium which has 4GB of memory. In monitoring the RAM consumption is more than 3.3GB continuously. How to determine which process is consuming ...
0
votes
0answers
14 views

How to get `psql` to fall back to password authentication with GSS enabled server

How can I use psql to authenticate to a GSSAPI enabled PostgreSQL server without getting a Kerberos ticket (i.e. by just typing the password). The PostgreSQL server is working just fine with GSSAPI ...
1
vote
0answers
28 views

Persist statistics data from Postgres' stats_temp_directory on demand

We are investigating I/O load in one of our VMs and possibilities to optimize it and it showed that most of the load is generated by the stats collector of PostgreSQL. It jumps between 3,5 and 6,5 ...
2
votes
1answer
51 views

Postgresql fails on startup: “FATAL: postmaster became multithreaded during startup”

Trying to start PostgreSQL, but get the following error: $ pg_ctl -D postgres_data start server starting FATAL: postmaster became multithreaded during startup HINT: Set the LC_ALL environment ...
0
votes
0answers
51 views

unixODBC on CentOS 6.7 with PostgreSQL 9.3

I am attempting to connect to a PostgreSQL 9.3 database on a Debian machine, more specifically an Ubuntu 14.04 machine using unixODBC. I am able to connect via the psql command using the same user ...