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)

19
votes
3answers
388 views

Risk of starting NTP on database server?

I've heard rumors of bad things happening to database and mail servers if you change the system time while they are running. However, I'm having a hard time finding any concrete information on actual ...
0
votes
1answer
27 views

PgBouncer not listening with no errors in logs

I currently have Postgres working on my server want to move to connection pooling. Looking around and PgBouncer seems to be the tool of choice. I have set it up and it claims to start fine with the ...
0
votes
1answer
1k views

HAProxy pgsql-check error

I use HAProxy 1.5-dev21 to load balance PostgreSQL connections over some read-only Postgresql 9.2 servers. Version 1.5 of HAProxy implements a pgsql-check option, similar to mysql-check. Here is my ...
-2
votes
0answers
18 views

How to reconfigure PostgreSQL PGDATA in Fedora 21?

I noticed there is a wiki page about the topic. It suggested me to create the file /etc/systemd/system/postgresql.service with this content: .include /lib/systemd/system/postgresql.service [Service] ...
0
votes
2answers
2k views

How to make a JDBC connect to Crystal Reports with Postgres

I want to create a new report using Crystal Reports. I downloaded the Postgres driver but when I want to create the connection, it shows an error "JDBC Driver not found" How can I solve it? Thanks ...
1
vote
1answer
1k views

Postgres's pg_basebackup never finishes creating backup

I'm attempting to move files to another server to setup a slave. I have a database on one Postgres Server and am attempting to create a file-based backup using pg_backup. However, it never finishes ...
0
votes
0answers
56 views

PostgreSQL failover with Kubernetes

I've got master slave replication working with Kubernetes, but would now like to implement failover. I have pods running with the service=postgresql and role=master or role=slave roles. When the ...
0
votes
0answers
8 views

Can I implement WCF wtih Postgres? [closed]

I am developing a WPF application, with Prism Unity. I am trying to implement WCF as described here: https://msdn.microsoft.com/en-us/library/ff649818.aspx. I thought I could just change the port to ...
0
votes
1answer
11 views

postgres continuous backup scheduling

I have set up Postgres conintuous backup by making a base backup and archiving WAL files, as specified here. Our database is very low use (but very important to back up) so we produce a new WAL file ...
5
votes
3answers
3k views

Periodic spiky CPU usage by winlogon / LogonUI

I've noticed that my AWS server occasionally starts using a bunch of CPU for no particular reason, looking something like this: Observe that it does not occur at specific times, but has a very ...
1
vote
0answers
26 views

How can I efficiently create daily write replicas of an RDS instance?

We're looking to create a replica of a postgres RDS instance that our developers can write to (not just a simple read replica that AWS can easily provide). Currently we run a script nightly that ...
3
votes
2answers
4k views

pgAdmin cannot connect to PostgreSQL 9.1

I am trying to use pgAdmin on Windows to connect to postgresql 9.1.8 running on localhost's Ubuntu 12.04 VM. The host's port 5432 forwards to VM's port 5432. pgAdmin Error: Error connecting to the ...
2
votes
2answers
148 views

Database backup encryption

I've been trying to work out an effective database backup encryption scheme lately. I have a Postgres 9.4 server, I have most of the backup scheme fleshed out I think. Backups will be stored in a ...
0
votes
1answer
33 views

terminating connection because of crash of another server process

I have a java scraper that spawns around 1,500-2,100 threads, each of which connects to the same database via jdbc and makes inserts. These threads insert quite frequently. It seems like the db ...
1
vote
3answers
3k views

psql: FATAL: could not write init file

as the title points out, I'm getting this error when trying to connect to a PostgreSql database from command line, using PostgreSQL. The client machine is an Ubuntu 11.10 x86_64 and the PostgreSQL ...
-1
votes
0answers
27 views

Database server: E5-2620v2 MLC SSD Software RAID1 vs E5-2650 Hardware RAID 10 / 2X RAID 1 for read performance and reliability [duplicate]

I am looking for a new database server and I have 2 options at this point with multiple configurations, all assuming same price. This will be a PostgreSQL database server with lots of READ (we are ...
1
vote
1answer
7k views

How do I fix issue causing “incomplete startup packet” log message trying to implement replication in Postgresql?

I've got two cloud servers running Ubuntu 13.04 and PostgreSQL 9.2. I've primarily used this blog post to aid me in setting things up. However, to do the initial database dump to the slave I'm using ...
2
votes
1answer
2k views

What should the permissions be on for PostgreSQL /data files?

I installed Postgres 9.3 from the osX binary. When I attempted to restart using pg_ctl restart, I received the following error: $ pg_ctl restart pg_ctl: could not open PID file ...
1
vote
1answer
988 views

Error in osm data data import while nominatim installation

I am doing nominatim installation on my server. I run the following command ./utils/setup.php --osm-file /usr/share/osm2pgsql/planetfile/planet-latest.osm.pbf --all to import the pbf file and Few ...
1
vote
1answer
27 views

Use in-memory database or search engine for read only to make website faster

I have an application which require doing a lot of queries for every single page which make it slower. I have tried to use cache systems (Redis) but implementation are little bit complicated and will ...
0
votes
0answers
24 views

Using PostgreSQL at web host, editing pg_hba.conf

I have a domain at HelioHost.org, where I want to connect to a PostgreSQL server, which they supposedly support. But I get the following error message when looking at my PHP files in Firefox: ...
0
votes
1answer
35 views

PostgreSQL: error with pg_hba.conf

I am trying to connect with Django to a PostgreSQL database I set up on a remote machine. I get the following error: django.db.utils.OperationalError: FATAL: no pg_hba.conf entry for host "::1", ...
0
votes
1answer
1k views

Why is hash join slow in postgresql 9.1?

I transfered my DB from Postgresql 8.4 to new server with Postgresql 9.1. Size of DB is 9.9GB Data directory is situated on ssd 60GB disk. And server has 16GB RAM and 16 proccessor cores. But today ...
1
vote
1answer
1k views

Postgres on OS X can't find postgis extension control file

Using mac OSX Yosemite 10.10.1. I uninstalled and re-installed both postgres and postgis with homebrew. I understand that postgres is looking in the wrong place for the postgis control file. Also ...
1
vote
1answer
1k views

“Could not create IPv6 socket” postgresql standby error

I'm trying to create Postgresql 9.1 hot-standby using following steps: Configured 2 virtual linux machines. Master's ip: 10.10.10.1, Standby's ip: 10.10.10.2. Ping test passed. Restored the same db ...
1
vote
1answer
1k views

Can't get postgres and kerberos (gss) working together

I am trying to get postgres and kerberos, via GSSAPI, working together. Having trouble at this point. It does not help that I am really a newbie for both technologies. I have both postgres and ...
0
votes
1answer
1k views

Postgres pgpass windows - not working

DB: Postgres 9.0 Client: Windows 7 Server Windows 2008, 64bit I'm trying to connect remotely to a postgres instance for purposes of performing a pg_dump to my local machine. Everything works from my ...
0
votes
0answers
28 views

How to install Nomtimatim in postgresql (windows)

I am trying to do geocoding in the postgresql, and I have already installed TIGER geocoder successfully. Then, I want to use Nomtimatim in postgresql. However,since the installed guide ...
0
votes
1answer
19 views

.pgpass file does not set default username to connect as

(Debian 8) My .pgpass file is at my home folder (admin) I and using the right format as indicated in the documentation hostname:port:database:username:password The same fields I put there work ...
0
votes
1answer
22 views

NAS suitable for this situation? [closed]

I work from home and am considering getting a NAS. Would using a NAS be suitable for my situation: I alternate working from a desktop and laptop, both of which run Linux I use PostgreSQL a lot along ...
-4
votes
2answers
59 views

Does anyone know of a good free tool that can be used to ping our Postgres database server to determine if it is running or not? [closed]

I'm looking for a free tool which runs on my desktop (not the server itself) that will periodically test to see if our database server is up and running properly. Ideally, it should also be able to ...
2
votes
2answers
3k views

issue in installing postgresql 9.3.4 on Windows server 2003 x64

Hello i really did all what i know to install the PostgreSQL 9.3.4 on my windows 2003 server x64, but i'm always stopped with this error : please see the error : http://oi57.tinypic.com/s4tb8i.jpg I ...
0
votes
1answer
50 views

fail to start postgresql when used with vagrant

Trying to start postgresql on a Virtualbox VM managed by Vagrant I have the following error: LOG: could not link file "pg_xlog/xlogtemp.29" to "pg_xlog/000000010000000000000001" (initialization of ...
0
votes
3answers
719 views

Dovecot - auth error permission denied

The following log file arises off my current maillog: Apr 24 17:44:48 h2290750 dovecot: auth: Error: pgsql: Connect failed to mail: could not connect to server: Permission denied Apr 24 17:44:48 ...
2
votes
2answers
176 views

AWS RDS Postgres Upgrade without losing data

I currently have a Postgresql v9.3.3 running on AWS RDS. I've learned that if I upgrade Postgres to 9.3.5 that I can create read replicas. However, I am afraid of losing data. Can I just select ...
0
votes
2answers
50 views

How to grant access to /var/run to postgres on CentOS?

After installing postgres-9.3 via yum in my CentOS 7, its default configuration puts socket in /tmp directory. I have httpd (installed via yum as well) which is by default managed by system.d with ...
0
votes
4answers
11k views

Location of postgresql.conf and pg_hba.conf on an Ubuntu server

Where are the files postgresql.conf and pg_hba.conf on a Linux server running PostgreSQL 8.4 installed from Ubuntu repos?
4
votes
2answers
3k views

Change and initialize Postgresql 9.3 default data and log directories on Ubuntu 12.04 LTS

On Azure with Ubuntu 12.04 LTS image, we're trying to change Postgres 9.3 default data and log file paths and also initialize them for the first time on a secondary drive /mnt/pgdata. We've starting ...
149
votes
6answers
257k views

What's the default superuser username/password for postgres after a new install?

I have just installed postgres 8.4 on Ubuntu 9.10 and it has never asked me to create a superuser. Is there a default superuser and its password? If not, how do I create a new one?
0
votes
0answers
72 views

OS X Yosemite Server - Wiki stops working

the last couple of days I have noticed that the Wiki-Server on OS X Server seems to crash. When I call up the wiki's website I get the following message: Caught exception "Connection to DB failed" ...
2
votes
2answers
5k views

How to restore a file system level copy of a PostgreSQL database (not dump) to a different PC

I am new to PostgreSQL. I have to recover a database which was running in widows XP machine. I have the zip folder of postgres. I have extracted postgres installation in a different PC and started a ...
1
vote
2answers
72 views

Automate pg_dump in a bash script

I am re-learning bash after years of not using it very much and need to figure out a way to automate pg_dump of a single database to a directory. Currently I manually ssh into the box, su to postgres ...
1
vote
2answers
5k views

How to completly remove postgresql from Ubuntu 13.04?

I've tried sudo apt-get purge postgresql sudo apt-get autoremove postgresql and sudo apt-get --purge remove postgresql But after this dpkg -l | grep postgres gives me that: pi postgresql-9.1 ...
0
votes
1answer
581 views

postgresql LDAP authentication

I am trying to give an LDAP authentication to my postgresql database. Here is my pg_hba.conf config file local all all md5 local all postgres md5 host all all 0.0.0.0/0 ldap ...
0
votes
1answer
81 views

No space left on device error

I can no longer generate new columns in my database. My stack is below. I am new to managing my own server and am unfamiliar with Apache, Ubuntu and AWS. Currently I am receiving an error saying ...
1
vote
0answers
180 views

PostgreSQL - Invalid byte sequence for encoding “UTF8”: 0xe7 0x75 0x20

Here is the problem : Everything worked fine with my postgresql system until I decided to click on the "rotate logs" button in the server status tab (from pgAdmin). After that, I faced this issue, ...
0
votes
0answers
62 views

Postgresql Connection Timed out

when I am connecting to psql on remote server >psql -h {hostname} psql: could not connect to server: Connection timed out (0x0000274C/10060). Is the server running on host "{hostname}" ...
0
votes
1answer
41 views

Ubuntu 14.04 having two postgres server, removing one

after installing postgres using apt-get and adding the repo for 9.4, I have two versions, 9.3 and 9.4 running. How can I remove 9.3? apt-get purge removes both actually. Thanks ins advance
1
vote
4answers
3k views

PostgreSQL didn't install on Ubuntu 11.04

On a new copy of Ubuntu 11.04 server I am trying to install PostgreSQL server by apt-get install postgresql. But in the end of installation log I saw: Error: could not create default cluster. Please ...
0
votes
1answer
56 views

MD5 pw encryption in postgresql using CREATE USER WITH PASSWORD

So I have postgresql database and in pg_hba.conf file I am authenticating users via md5. I typically create users using the command: CREATE USER username WITH PASSWORD 'password'; From the ...