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
2answers
20 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
16 views

Server migration with the shortest possible downtime [on hold]

If it was the same network and localization I'd simply do: 1. set up new server with nginx, ruby, rails and passenger 2. set up postgres data replication with new server as master 3. a) if load ...
-1
votes
0answers
25 views

Why database performance decrease in different data centers? [on hold]

I'm trying to migrate all our infrastructure to the cloud. In order to do that, we need to ensure that our application performance would, at least, be the same. So we set 2 environment with our ...
0
votes
0answers
6 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
13 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
22 views

How to insert values into point[] in postgreSQL? [on hold]

How to insert values into array of point[] in postgreSQL ?
0
votes
0answers
12 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
6 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
44 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
5 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
3 views

Postgresql perl : “NOTICE: elseif should be elsif at line …” [migrated]

It's not the first time I get this strange NOTICE when adding perl functions in Postgresql : NOTICE: elseif should be elsif at line 11. This happens at CREATE FUNCTION as well as when using the ...
0
votes
0answers
12 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
26 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
64 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
38 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
33 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
35 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
62 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
27 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
16 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
53 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
37 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
40 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
13 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
27 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
22 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
53 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
26 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
32 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
58 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
22 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
43 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
59 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
25 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/...
0
votes
2answers
73 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
58 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
118 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
158 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
46 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
122 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
25 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
120 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 ...