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
0answers
2 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 HOWVER In postgresql documentation it ...
0
votes
0answers
22 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
19 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
26 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
9 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 ...
1
vote
0answers
25 views

How to estimate PostgreSQL reindexing time? [migrated]

How do you estimate the total time reindexing an entire table will take in PostgreSQL? I have a large PostgreSQL database, the primary table of which has 15 million records and 100 columns, and 200 ...
1
vote
1answer
29 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
14 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
0answers
5 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
21 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
6 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
18 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
11 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
4 views

Dealing with partitioned tables in Postgresql [migrated]

Due to historical reasons we used to use one really big table in our Postgresql database to store time-based series of measurements. After a long usage, as the table become 200+ Gb in size, we decided ...
0
votes
0answers
18 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
25 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
38 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 ...
2
votes
1answer
40 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
25 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 ...
0
votes
1answer
27 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 ...
0
votes
0answers
22 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
21 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
85 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
25 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 ...
1
vote
0answers
56 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 ...
0
votes
0answers
26 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
36 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
9 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
73 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
65 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 ...
1
vote
0answers
8 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
18 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
3answers
38 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
17 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 ...
0
votes
1answer
43 views

'Invalid input syntax for type inet' db error in Django app with postgres when Gunicorn+Nginx(reverse proxy) installed

I have a Django app with postgres back-end where I'm configuring gunicorn to work behind nginx as reverse proxy. My machine runs Ubuntu 14.04. Everything seems to have worked, except I've run into a ...
1
vote
1answer
220 views

Cannot upgrade postgresql 9.4 -> 9.5beta2 after postgis 2.1.6 -> 2.2.0 upgrade

Here is my situation: I started with Postgresql 9.4.5 and Postgis 2.1.6. Everything running smoothly. Both are installed from source. I upgraded Postgis to 2.2.0 (download source, configure, make, ...
0
votes
1answer
68 views

Postgres 9.5 server not starting due to already active replication slot

I have a Postgres (version - 9.5 Beta) server replication set up where there are 3 slaves and a primary server. After all required configuration is done, I start 1st slave after taking base backup and ...
0
votes
1answer
40 views

psql: duplicate GSS authentication request

What does it mean by saying 'duplicate' ? How to troubleshoot this? guest@www:~$ klist Ticket cache: FILE:/tmp/krb5cc_1000 Default principal: user/admin@SOHONET Valid starting Expires ...
0
votes
1answer
15 views

How to start postgresql server with the socket at a different place?

Good morning. The title says it, but let me precise it. I am working with openbsd. The web server is chrooted in /var/www. So the good thing would be that postgresgl place its socket (and the lock, I ...
0
votes
0answers
4 views

How do I resynchronize a Bacula catalog?

I tried performing a Bacula upgrade, but found there were issues with our architecture. Our team tried powering through the upgrade testing backups, but eventually decided to do a downgrade and ...
0
votes
2answers
48 views

Docker Architecture for Multiple Apps with Postgres DB

I have over 30 apps written in various Ruby frameworks. All of them are internal apps so they receive very little traffic. I want to run each of them in a separate Docker container. All of them use ...
1
vote
1answer
17 views

Difference in time stamps via puppetdb query and mysql query

I store reports from nodes in puppetdb. I want to check time when reports received from specific node via the following query: curl -sk http://pdb:8080/v3/reports --data-urlencode 'query=["=", ...
1
vote
1answer
147 views

Can not start PostgreSQL replication resource with Corosync/Pacemaker

I'm setting up a PostgreSQL replication on two servers (CentOS 6.5) with HA by Corosync/Pacemaker. My software info: postgresql91-9.1.19-1PGDG.rhel6.x86_64 ...
0
votes
1answer
46 views

Slot replication not working in Postgres 9.4

I am using Postgres 9.4 on Windows 2008 server. There are three such instances that I am using. One as master and the rest of the two are slave/standby. The version of Postgres is 9.4 in all the three ...
2
votes
1answer
27 views

Is there a way to write application logs like Tomcat and PostgreSQL to Tenable Log Correlation Engine?

My IT group uses Tenable's Log Correlation Engine and we have our Linux servers writing syslog to LCE. Is there a way to write our Tomcat and PostgreSQL application logs to LCE?
0
votes
1answer
25 views

How to debug remote connection failure to a postgresql database? [closed]

I'm a new user and I hope to get it right. However I've a problem with a remote access to postgresql. I've changed postgresql.conf (listen_addresses = '*') and I've changed pg_hba.conf (I've added ...
0
votes
1answer
38 views

psql: could not connect to server: Network is unreachable

I know it is a duplicate questions but their solution not working, What I'm doing is, connecting to a remote Postgresql database from my local ubunut machine: psql -h x.x.x.x -U username But it ...
0
votes
1answer
72 views

Millions of requests and MariaDB vs. PostgreSQL

I do not ask for comparison. I already know what PostgreSQL and MariaDB is and differences. I am looking this issue from another point. Such companies like Facebook uses MySQL (of course patched) but ...
0
votes
1answer
21 views

Is it possible to connect to a PostgreSQL server using FreeTDS driver and tsql?

Can I make a connection to a PostgreSQL server using FreeTDS, more specifically tsql command? I've been trying for a few days now, using many different configurations. Even though I am able to ...