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
21 views

How can I force PostgreSQL to start after network is setup on Ubuntu Server 16?

PostgreSQL fails to bind socket because it starts before network is setup. I use Ubuntu Server 16.04.1 LTS and PostgreSQL 9.5. I have read many docs over the internet but nothing solved my problem. ...
0
votes
0answers
11 views

postgresql log shipping doesn't seem to work

There are two servers. One is the on-site database server; the other is the off-site backup server. Since the on-site database server already contains just shy of 900G of data, backups are important. ...
0
votes
0answers
15 views

Postgres autovacuum errors while restoring a dump

Restoring a dump on a Ubuntu 16.04 system takes several hours. Autovacuum is just canceled after waiting more than 3 hours (10926330.443 ms): 2016-07-20 05:20:00 CEST [78652-2414] LOCATION: ...
0
votes
1answer
41 views

ZFS: ARC and buffer cache with PostgreSQL

I am using Ubuntu Xenial, zfs and PostgreSQL 9.5 with all updates available atm. All testing is done on EC2 m4.xlarge (8GB RAM) and table size ~4GB. PostgreSQL effective_cache_size=6GB. First ...
0
votes
0answers
20 views

Postgres 9.5: Restoring dumps is very very slow

After updating server (and also the pc for additional tests) to Postgres 9.5 I tried to import PG 9.4 dumps and/or to restore 9.5 dumps: pg_dump testdb > db.sql psql -d testdb -f db.sql ...
0
votes
1answer
14 views

Accessing to a remote PostgreSQL server using port forwarding to another machine

I try to access to a Server_A on which PostgreSQL is running. This server is on a local network, that's why I have to forward port from Server_B which is accessible and in the same network. To access ...
2
votes
1answer
47 views

Update Postgres on Production Server without downtime

I have a production server running Postgres 9.4. The database is > 10 GB. Is it possible to upgrade to Postgres 9.5 without downtime and without loosing data? Upgrade tutorials recommend to stop ...
0
votes
1answer
26 views

postgresql port closed for remote access

I'm trying to connect to a PostgreSQL database in an Ubuntu Server, which I have root access, but somehow I can't open port 5432 for remote access, just local. This is what happens when I use "nmap" ...
0
votes
1answer
32 views

issues configuring firewall rules for Postgres on Centos

I am attempting to follow this guide to allow remote connections to postgres http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.html At the moment I am running into issues with ...
0
votes
0answers
32 views

PostgreSQL - Force user to change password

Is there a way to force users of PostgreSQL to change their password at the first connection? Password validity only takes a timestamp argument and I haven't found an option to prompt the user for a ...
0
votes
1answer
64 views

Why should I use VPN in this scenario?

I have one web application, that is deployed on cloud. Now, this web application needs to access 3 Postgres databases, located in 3 different location(Lets call them, client systems). So one day, I ...
0
votes
1answer
4 views

Making temp_tablespaces favor certain tablespaces over others

I've got three tablespaces. Two of them are on disks with ~400GiB free, and one is on a disk with ~200GiB free. I want to set up temp_tablespaces to use the latter disk less frequently in case I run ...
0
votes
1answer
17 views

How to install Postgis with Osm2pgsql on NixOS

When installing PostGIS on NixOS with an expression like services.postgresql.extraPlugins = [ (pkgs.postgis.override { postgresql = pkgs.postgresql94; }).v_2_1_4 ]; How to add other extensions ...
0
votes
1answer
20 views

importing data into Amazon RDS extremely slow

I need to import a PostgresSql db from an old server into a new Amazon RDS. I created a db dump file, connected to my RDS via pgAdmin, and started to import pgAdmin console (\i dump_file.sql). ...
0
votes
1answer
29 views

PostgreSQL not listening on local eth1 after reboot

I have a server with 2 networking interfaces - global on eth0, and local on eth1 with IP like 10.181.xx.xx. Running Ubuntu 16.04. I set up PostgreSQL to listen on this local address, so another ...
0
votes
1answer
23 views

PHP cant connect to postgreSQL in Centos 7 Selinux

After migration to a new VPS and trying website on new server(Centos 7), Selinux somehow prevents http from accessing Postgresql: pg_connect(): Unable to connect to PostgreSQL server: could not ...
1
vote
2answers
24 views

How do I include the password for the user 'postgres' in a maintenance script?

I'm setting up a cron job to do some routine maintenance for a postgresql database. The script is as follows: #!/bin/sh dbname="dbname" username="postgres" psql -d $dbname -U $username << EOF ...
0
votes
0answers
12 views

parallize postgres queries with bash and psql?

I'm trying to run a series of postgres functions/stored-procedures that operate on separate tables in parallel using bash + psql as follows: psql -d samples_20160612_0616 -c "select insert_function('...
0
votes
2answers
49 views

Getting Too many Open files error for Postgres

In Ubuntu 14.04 server on a JAVA application we are getting Too many Open files error for Postgres (Using Postgresql 9.5). We set the following in /etc/security/limits.conf * soft nofile 16384 * ...
-3
votes
1answer
28 views

How to insert values into point array in postgreSQL? [closed]

How to insert values into array of point in postgreSQL ?
0
votes
0answers
17 views

Can I rotate/truncate a single logfile in PostgreSQL 9.4?

I want to setup my test PostgreSQL instance in a VM so that is logs queries to a single file (postgresql.log), which is rotated every hour. Using examples from the docs, I've added the following to ...
0
votes
0answers
10 views

Setup master master for postgres with one is Amazon RDS and another one external?

Is it possible to setup master master for postgres with one is Amazon RDS and another one external? My circumstance is I'm currently using postgres on Amazon RDS but I want to add another server in ...
0
votes
0answers
26 views

Postgres shared buffers tricking Linux into swapping? [duplicate]

Why is my system swapping when I have 45GiB of "cached Mem"? Is Postgres causing problems by using a lot of SHR memory? Here's my situation: 12 cores, 64GiB of RAM on my server running Ubuntu ...
1
vote
1answer
98 views

Postgresql replication with pgpool or pgbouncer

I'm looking for a good configuration for a postgresql replication with a robust failover strategy (self hosted). Actually, I configured two postgresql instances in master / slave with repmgr. Now, I ...
0
votes
0answers
13 views

Use pg_stat_statements extension on Hot Standby Slave

I've added pg_stat_statements in the postgresql.conf shared_preload_libraries = 'pg_stat_statements' # (change requires restart) and issued a restart afterwards using pg_ctlcluster 9.3 main ...
0
votes
0answers
24 views

Use EC2 instance as proxy to client's VPN

I have a client who has given me access to their database over a VPN. I need my web application to also connect to the same database. My current approach is: Create a new EC2 micro instance (...
0
votes
0answers
47 views

Dovecot/Postfix mail server SASL: Connect to private/auth failed

Trying to get this mail sever up has eaten up a good chunk of 2 days and I've made some headway but this specific error has persisted throughout. I'm using a Debian server with Postfix + Dovecot + ...
0
votes
1answer
70 views

Unable to connect to Postgresql on a server

On Digital Ocean I'm able to connect to Postgresql: psql -d my_db -U my_name for which it asks me a password and I get in successfully. But from my local computer I'm unable: psql -d my_db -U ...
0
votes
1answer
42 views

Is it possible to do database replication on aws s3

I have 4TB database in company. As many different analytics require that full data the current database is not able to handle concurrent session from 100s of users. Is it possible to have databse ...
0
votes
1answer
56 views

Postgres doesn't shut down properly

Here is my original error: $ psql psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? ...
0
votes
1answer
70 views

Gitlab - Postgresql not working anymore after gitlabctl-reconfigure

I just installed a brand new server with Gitlab. The first time I done gitlab-ctl reconfigure it worked like a charm. After that, I didn't change anything but ran gitlab-ctl reconfigure again. This ...
0
votes
1answer
99 views

AWS RDS Postgres performance issue

We are using rds(postgres) with instance type as db.m4.2xlarge. Usually most of the time number of connections are 8-10. But on some occasion as the number of connections increases to 100-200. DB ...
0
votes
1answer
32 views

Sharepoint postgresql data connection

We are migrating our intranet to SharePoint and our previous system used postgresql so I'm trying to make it work with SharePoint, which is not easy. I tried to add a data source on SharePoint ...
0
votes
0answers
18 views

Strange Postgres PreparedStatement behaviour (JDBC)

i have a strange problem with the following parameterized PreparedStatement in Java: PreparedStatement ps=DBUtil.newPreparedStatement( "SELECT * FROM msg as m WHERE " + ...
0
votes
3answers
56 views

Verifying the reason why people say it's not a good practice to let an app connect to your db directly

I'm working with postgre (AWS RDS) for my db and using node (AWS EC2) for server side. I'm just starting out so I don't have much context. I always used other third party software like Parse for DB so ...
0
votes
1answer
58 views

Error no 14 while installing PostgreSQL using yum

I am trying to install PostgreSQL on RHEL 6.3 using yum. I am getting a error while installing postgreSQL using yum. Command: yum install postgresql95-server postgresql95 Error: Loaded ...
0
votes
1answer
57 views

Installing postgres on Cent OS

I am having a hard time getting postgres re-installed on Cent OS 7.2.Here is what I tried. Went to YUM repo of postgres Created a temporary folder on my machine for the RPM file Did wget https://...
0
votes
1answer
15 views

Unable to connect to Postgresql via login/password from my web app

On a server I'm able to connect to Postgresql via the terminal: $ psql -U me123 -d my_db psql (9.4.7) Type "help" for help. my_db=# \q Note that it didn't ask me for the password for some reason ...
0
votes
1answer
28 views

Execute postgres function on server from local

I've a postgres database on server. There is an upsert function which takes a file as an input. Is there any way to execute the upsert function from my local without having to scp the file to server ...
0
votes
1answer
25 views

How to share data between web applications?

I got two web applications, one customer facing and one for internal usage. Both are using a PostgreSQL database. What are the approaches I could take to share data between these applications? Both ...
0
votes
2answers
72 views

Why doesn't “psql -U” work for me?

I'm just starting with Postgres. This is a fresh install of Postgres 9.5 on Ubuntu 14.04 LTS. I used the apt repo from: http://www.postgresql.org/download/linux/ubuntu/ The intro page http://www....
0
votes
0answers
27 views

Cannot access nfs share

On my Debian 8.4 system, I would like to run a postgres database. The data should reside on an NFS mounted folder. # cat /etc/fstab xxx.xxx.xxx.xxx:/volume1/srvPostgres on /var/lib/postgresql type ...
0
votes
1answer
40 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 ...
0
votes
1answer
82 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
26 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 = /var/...
0
votes
1answer
55 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
22 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 ...
0
votes
0answers
85 views

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
19 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 ...
0
votes
2answers
26 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: http://www.cyberciti.biz/tips/...