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
2answers
86 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
80 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 ...
0
votes
1answer
158 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
19 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
237 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 ...
0
votes
2answers
59 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
173 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 "/var/...
2
votes
1answer
26 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 ...
3
votes
0answers
163 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
55 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
48 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 ...
1
vote
0answers
104 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 (http://www.postgresql.org/docs/9.4/static/installation....
0
votes
0answers
22 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
14 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 ...
-2
votes
1answer
57 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
19 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
34 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, contact@...
1
vote
1answer
88 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
134 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
24 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
59 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
61 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
77 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
32 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 multi-...
-2
votes
1answer
41 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 /usr/share/perl5/...
1
vote
2answers
59 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
96 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: https://www.andreagrandi.it/2015/02/21/how-to-create-a-...
0
votes
1answer
50 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
342 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
38 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 ...
2
votes
3answers
213 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 remotely,...
0
votes
1answer
59 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
195 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
72 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
18 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: pgsql:/etc/postfix/pgsql/relay_domains.cf(0,lock|...
0
votes
1answer
51 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
18 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
34 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 MB/...
2
votes
1answer
98 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
73 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 ...
0
votes
0answers
63 views

PG, Redis, and Elasticsearch replication for 2 distant metal servers

After years of running a web app on ~15 separate VPS, I'm switching to a single physical server*. App uses 3 DBs: Postgres, Redis, and Elasticsearch, and can update to latest version on all 3. ...
0
votes
1answer
168 views

How to change Default Port used by PostgreSQL 9.5 on CentOS 7?

Does someone have an idea about how to change default port for PostgreSQL 9.5, I did the same on previous versions and I just modify the following files: /var/lib/pgsql/9.5/data/postgresql.conf ...
4
votes
1answer
141 views

AWS RDS keeps backing up my server on creation

I am using Amazon CloudFormation to create a Stack with EC2 and RDS (Postgres 9.4.4, 5gb, db.m1.small). The RDS instance initiates a backup as soon as it starts. How can I stop RDS from backing it up ...
1
vote
1answer
92 views

Howto Byte-level “offline” backup of postgresql database

I am trying to love PostGreSQL. I'm pushing it at my company. I want us to adopt it for more and more projects. But I am personally stumped by a backup/restore issue. I keep thinking, if this was MS-...
0
votes
1answer
133 views

Upgrading PostgreSQL on EC2 with minimum impact to existing configuration

I have PostgreSQL 9.2 installed on an EC2 instance, with yum install. I now need to upgrade to PostgreSQL 9.4. I've noticed that yum list lists 9.2, 9.3 and 9.4 as completely separate packages, so I ...
1
vote
0answers
94 views

Using PGPASSWORD variable does not seem to work any more on Postgresql 9.3

In Posgresql you can set a variable called PGPASSWORD (and PGUSER) so you don't have to use password when using postgresql commands such as psql or pg_dump But I am a bit confused because I can't ...
0
votes
0answers
8 views

phpPgAdmin - maximum number of concurrent users? [duplicate]

I have recently set up an Ubuntu server with Apache, PHP and phpPgAdmin. I want a group of people to be able to simultaneously run queries against our testing PostgreSQL database as needed, accessing ...
0
votes
0answers
57 views

How do I perform a remote service stop and Postgresql backup using powershell?

I am having some difficulty with a Powershell script. The script runs nightly to perform a backup of a Postgresql db. I used WinRM to allow the server running the script to perform the service ...
0
votes
1answer
615 views

Postgresql Error: could not receive data from client: Connection reset by peer

I try this stack: nginx + uwsgi + django + postgresql, the request can reach to views of django, client show 500 server internal fault, I check postgres log, found the error could not receive data ...