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
0answers
82 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
13 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
53 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
15 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
31 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
58 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
97 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
52 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
53 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
65 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
26 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
39 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
53 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
87 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
46 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
286 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
37 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 ...
1
vote
2answers
162 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
39 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
142 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
57 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
17 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
43 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
17 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
32 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
86 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
70 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
56 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
141 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
138 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
80 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
115 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
76 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
50 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
551 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 ...
0
votes
1answer
35 views

How to call ftp script from main script

I'm lookign for a way to create backups from several databases and send result files to server in Debian Linux 6 (Sqeeze) from crontab job There are databases named database1 .. database4 Backup from ...
2
votes
0answers
401 views

Postgresql 9.4 clusters not auto starting on Debian

I have Debian 8.2 x64 and Postgresql 9.4 (from repo). I've recreated default cluster in different location like this: # service postgresql stop # pg_dropcluster 9.4 main # pg_createcluster -d /srv/...
0
votes
0answers
116 views

How to recover a Standby in Postgres Slot Replication

I am using 4 nodes of Postgres 9.5 server in a Slot replication set up. One node is acting as a Master and three other nodes as Standby nodes. Everything ran fine for few days and suddenly one node ...
1
vote
1answer
123 views

Unable to restore postgresql data dump for Django app hosted on Azure VM

I am trying to restore a postgres data dump for a Django app of mine. The data dump was extracted from Heroku, and pg_restore is being run on an Azure VM with Linux on it. There are around 40 tables ...
0
votes
0answers
24 views

How to configure a PostgreSQL GIN index to support partial matches

I'm currently using a GIN index to do lightening fast full text search queries in PostgreSQL. It works great, with the only exception being it doesn't seem to handle partial-word searches. e.g. ...
1
vote
0answers
209 views

How to automate failover of master in PostgreSQL 9.5 on Windows?

I have 4 nodes (version - PostgreSQL 9.5 Beta) in a slot replication set up. Recently the master node, due to less disk space available, PostgreSQL started throwing errors and crashed in the end. As I ...
0
votes
2answers
67 views

Unable to get permissions even after changing permissions on a mounted directory in ubuntu 14.01

This is an ext4 fs and I am unable to gain permissions over the directory with the postgres user: mud@mud-i7-32gb:~$ sudo mount /dev/sdc1 /media/mud/ssd128 mud@mud-i7-32gb:~$ ls -l /media/mud/...
1
vote
0answers
12 views

Show or log long queries with values instead placeholders

I have any very long sql query in postgresql. I tried show what postgress do with: select * from pg_stat_activity unfortunately I see something like: select some_fields from anytable1 anytable2 ...
1
vote
1answer
57 views

Running postgres_database.present a second time causes error “has wrong parameters which couldn't be changed on fly”

Running a salt state that looks like the following to create a postgres database for django... django-db: postgres_database.present: - encoding: 'UTF-8' - owner: djangouser - db_user: ...
-1
votes
2answers
48 views

How to move PostgreSQL data directory?

My PostgreSQL installation by default uses /var/lib/pgsql directory to store data, backups and configuration files. As my disk space is running out, I have installed new hardware and mounted it in the ...
0
votes
0answers
23 views

Two PostgreSQL 9.5 beta 2 - short replication howto

Try configure native bi-direction (synchronous) replication between two postgresql 9.5 beta 2. Read many official documents, but still dont understand what I need configure in postgresql.conf Any ...