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
9 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
0answers
3 views

How to start Postgres on OS 10.11 at login using plist?

I want Postgres to launch when I login. My installation uses port 5431 (instead of the default 5432), and I can't find a sample .plist that passes in the port. I think mine is wrong. Can someone tell ...
0
votes
0answers
8 views

Promote Slave to Master with PostgreSQL and Docker

I'm trying to make a postgreSQL infrastructure with master and slave inside docker containers. With normal installation of postgres is possible to promote a slave to master if the first master fail. ...
0
votes
0answers
6 views

Pgpool - Automatically attaching unattached nodes

I would like to write some kind of an agent that will check my master and slave/slaves machines and attach them to the pool if they become unattached. I will be happy to get code sample or advice ...
0
votes
1answer
17 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
16 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
30 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
21 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
10 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 " + ...
-1
votes
3answers
48 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
16 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 ...
-1
votes
1answer
27 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 ...
0
votes
1answer
10 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
26 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
18 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 ...
1
vote
2answers
42 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 ...
0
votes
0answers
23 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 ...
1
vote
1answer
26 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 ...
1
vote
1answer
34 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
19 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 = ...
1
vote
1answer
34 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
21 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 ...
1
vote
0answers
48 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 ...
1
vote
2answers
23 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: ...
0
votes
2answers
65 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
49 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
79 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
111 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 ...
1
vote
2answers
40 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
91 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 ...
2
votes
1answer
23 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 ...
2
votes
0answers
88 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
38 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
39 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
61 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 ...
0
votes
0answers
21 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 ...
-3
votes
1answer
41 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
11 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
27 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, ...
1
vote
1answer
47 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
74 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
44 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
44 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
38 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
23 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 ...