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

PostgreSQL : Strange Sudden Data type AND select schema issue

Here is my problem : Actually I am using postgresql 9.4 and postGIS extension. I am creating a database, and adding new tables with no problems... with geometry data types... until now... Now, I ...
0
votes
1answer
28 views

Postgres /root": Permission denied

why on ubuntu 14.10 every time that i try to start the postgres on: sudo -p 'sudo password: ' -u postgres /usr/lib/postgresql/9.4/bin/initdb -D /mnt/postgresql/9.4/data show this: could not ...
1
vote
0answers
17 views

MongoDB versus Neo4j versus Postgres for 50M/daily requests application

I'm new both to MongoDB and Neo4j, but had experience in Postgres 9.3. I'm asking for suggestions/corrections/advices. I have an application that operates with tree data structure requires to ...
0
votes
1answer
38 views

repmgr - after a failover switch, both nodes act as a master

I have a two node PostgreSQL cluster configured through repmgr. The database topology looks like this: db1 - 10.10.10.50 ( master ) db2 - 10.10.10.60 ( standby ) wit - 10.10.10.70 ( witness ) The ...
-1
votes
0answers
14 views

LoadBalance/Proxy Postgres with HAproxy based on Host/DomainName

0 down vote favorite I have multiple Postgres databased in test, that i would like to use HaProxy to proxy my request to diffrent postgres database. db1.test.loc -> database1 db2.test.loc ...
1
vote
1answer
19 views

Installing postgres 9.4 on ubuntu with a non-default database directory

I am trying to install and set up postgres 9.4 on ubuntu 14.04. What is the best way to install postgres whilst ensuring all created tables and databases (and anything else that could potentially ...
0
votes
0answers
12 views

Collectd not sending Postgres stats

I am trying to add postgres stats collection to collectd. I have collectd running on the server running postgres and it is successfully sending the metrics for; cpu, disk, memory, network etc to ...
1
vote
1answer
17 views

Install PostgreSQL pgAdmin Tools on Amazon RDS

Is there a way to install the optional adminpack (contrib) tools for utilizing pgAdmin on an Amazon RDS PostgreSQL instance? My gut says no because of this question. When you don't have the tools ...
0
votes
0answers
21 views

move all postgresql pgdata or only pg_xlog to raid0 and configuration of effective_io_concurrency in Azure

I setup 4 disks RAID0 in Azure VM (D11, 2 cores, 14GB ram) and moved pg_xlog to the RAID array and the rest of the pgsql/data on the OS disk which is a single disk. I wonder can I configure ...
0
votes
1answer
26 views

Load average spike causes very slow response on web application

we've a vm in Azure with D11(2 cores, 14GB ram) size to host our company new web erp system that consist of jboss and postgresql installed on centos 7, only 14 users login concurrently. From time to ...
0
votes
1answer
59 views

could not write temporary statistics file “pg_stat_tmp/pgstat.tmp”: No space left on device [closed]

The posgtres sudden stopped on the server and the logs shows the following error: 2015-08-18 02:29:22 IST ERROR: could not extend file "base/197893/198337": No space left on device 2015-08-18 ...
0
votes
1answer
19 views

Slony PostgreSQL replication - Can I create an index on a table on a slave that isn't on the master?

I have just set up a slony replication set up between 2 postgres servers. One master, and one slave host. Data is being copied. We don't want to use this for data backup or anything, but want to do ...
0
votes
2answers
58 views

Postgresql: restoring database from dump fails

I am using psql (9.3.9) on Ubuntu 14.04. I created dump of a database using command: pg_dump db1 > db1.backup I deleted the db and recreated it. Trying to restore it with psql -d db1 -f ...
0
votes
0answers
40 views

Google Container engine - mysql / postgresql image failure to connect from remote machine

I'm quite new to the docker images, containers and all the logic behind linking the running containers together, so please be patient if this question sounds too stupid. I'm trying to setup a working ...
0
votes
2answers
42 views

Pros and cons of database choice for OwnCloud [closed]

OwnCloud provides 3 choices for its database: SQLite MariaDB PostgreSQL Obviously SQLite is not a practical choice, since it can rarely handle the load. What about the other two? Is MariaDB or ...
0
votes
1answer
8 views

postgresql: 'invalid page header' message even after drop and recreate

My Ubuntu 14.04 LTS server running postgresql 8.4.11 crashed, and after a reboot the application server running a query against postgresql reported the following error ERROR: invalid page header in ...
0
votes
0answers
30 views

How do I run slony as a service on Ubuntu with /etc/init.d/slony1

I am investigating setting up Slony-I replication for 2 PostgreSQL databased on Ubuntu Trusty 14.04. I have gotten the basic replication working. But I have to start the slon command manually on each ...
0
votes
0answers
12 views

PostgreSQL install from source on a systemd distro

On my current server I have 2 versions of postgresql installed, postgresql-9.1 and postgresql-9.2 I installed them from source from the postgresql website. The tar.gz folder supplies the install ...
0
votes
2answers
22 views

How to take backup of a table on a different schema in PostgreSQL

Please let us know in PostgreSQL how we can take backup of a table on a different schema. We have db named "geopostgrest" and under Schema named "1" (Not inside Public Schema) we need to take backup ...
-2
votes
0answers
31 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] ...
1
vote
1answer
145 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
1answer
17 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 ...
1
vote
0answers
31 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 ...
2
votes
2answers
162 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
50 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
98 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
1answer
37 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
36 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
0answers
38 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
30 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
23 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 ...
0
votes
1answer
72 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", ...
-4
votes
2answers
65 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 ...
0
votes
1answer
92 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
2answers
67 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
0answers
150 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" ...
1
vote
2answers
113 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 ...
0
votes
1answer
108 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
427 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
1answer
106 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
117 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 ...
0
votes
1answer
81 views

How to import postgresql file on Linux with space in path?

If I try to import an sql script with a space in path, the file is not found. mypsqluser=> \i /home/markus/Documents/Projekte/My App/Installation/server_sql_script.sql ...
0
votes
2answers
83 views

Tuning Tomcat java app with Apache reverse proxy and Postgresql

Looks like my apache reverse proxy may be acting as the bottleneck and bogging down the number of requests users can make. I run Apache and Tomcat on server1, which has 96 gb RAM, rhel5 x64, 24 ...
0
votes
1answer
51 views

Postgresql 9.1 -> 9.4 migration problems

I've run a quick and dirty debian 7 -> debian 8 upgrade today, and lost my postgresql 9.1 installation. By "lost" i mean that i can't start it from init script (i simply get no output; 9.4 goes okay, ...
0
votes
1answer
45 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
0
votes
0answers
24 views

Fallback to backup server upon failure of main server without third machine

I will soon need to setup a database server on a budget. We are planning to use Postgres on Ubuntu (most likely) and we'd like to have a backup server. For replication, I think I'll just use ...
0
votes
0answers
53 views

pgpool2 stucks in “idle in transaction”

We have a setup with two postgresql servers configured as master-slave (streaming replication). The application servers (Odoo) should connect through pgpool2. All is fine if I connect the application ...
0
votes
1answer
63 views

How to export a Heroku-friendly Postgres dump from Ninefold?

I am trying to migrate my postgres database from ninefold to heroku. The command I'm using to export is: PGPASSWORD=password pg_dump -h ipaddress -p port -U user -d database -Fc --no-acl --no-owner ...
0
votes
1answer
10 views

Downsides to indefinite replicate streaming delays?

I have a db server that's sole purpose is for analytics querying. It's running as a hot standby, but long running queries are failing due to max_standby_archive_delay and max_standby_streaming_delay ...
0
votes
0answers
21 views

apache2 mod_dbd and postgresql

I'm trying to rewrite url using dbd. Everything looks ok, except few things: It doesn't work It doesn't show any error (LogLevel Trace8) It doesn't show any connection to database (postgresql.log ...