I'm trying to do nightly restores of the main database on a separate node. I want to do weekly full restores and nightly restores by consuming the latest WAL files.
On the master I have
wal_level = ...

I have just installed Postgres 9.1 on a server with 32GB of RAM and 320GB solid-state disk.
I will be using this server to serve both my site and my database (i.e. it's not just a database server). ...

Target : What i'm trying to achieve is to restore a partial backup of a database (only certain rows that satisfied certain conditions have been backed up).
Problem : Since between the partial-backup ...

Context : Our web-app is like a collaboration platform where you can share files, appointments, survey and so on. An instance of this web-app is divided in communities, each one is independent to each ...

Running Postgres 9.1 on Ubuntu 14.10 LTS.
I've got an application running on a machine that's going to run out of diskspace soon. However, the application is in the middle of a crucial run that has ...

I have been trying to issue a simple:
ALTER TABLE tablename ADD COLUMN id_col character varying (30)
type statement on a Postgres 9.1.13 build on Debian. The application is still in private beta, so ...

I have two tables, one stores structure (using so called parent field), the other entities that can be embeded into that structure. As certain level of structure can contain both entities and deeper ...

I've got a cluster of 9.1 servers running streaming replication and using WAL-E based log shipping for when that falls behind.
Generally speaking it's a pretty solid setup and does not fall behind, ...

I have a statement that selects from two tables news and status. It seems that the index on the column status of the table news is not used.
This table has about 70.000 rows and the query costs too ...

I am using a postgres DB to implement a scheduling of jobs for a large number of computers/processes. To make the story short, every job has its id, all scheduling is implemented with three tabes: all ...

I turned the archive_mode on on my postgresql configuration for testing a backup server . And since the wal files took lots of disk space, after my test I turned it off and also deleted the wal files. ...

I have a postgresql 9.1 installation where the available disk space is very low (20Gb) however there is only one client that inserts data in various tables (typically one entry every few minutes) and ...

I am trying to access the pg_settings table from a separate connection belonging to a legacy application.
I know how to identify the connection's procid from pg_stat_activity, but I am unsure how to ...

I am working on some unused data purging scripts on Postgres 9.1. VACUUM FULL is necessary to reclaim physical space after purging. However, with my data volume (5M+ rows), it takes several minutes ...