[GENERAL] corrupt data from invalid recovery

We are trying to help a client, one of their databases was being backed up via snapshots without running a pg_start_backup or pg_stop _backup Recently they had an issue and they recovered from one of these snapshot backups, which are now producing errors such as : Invalid page header in block X

[GENERAL] JSON Indexes

Hi All; We're struggling to get the planner to use a json index. I have this table : Table "public.mytest" Column | Type| Modifiers +---+- id | bigint| no

[GENERAL] HOT standby with ONLY WAL shipping?

Hi All; We would like to setup a hot standby server with a forced delay. Is it possible to setup a hot standby based ONLY on WAL shipping and NOT use streaming replication? Thanks in advance -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscri

[GENERAL] Replication failover on windows

Hi all; we have a client running PostgreSQL on windows, and they want to run streaming replication with some sort of failover. We have streaming replication in place, we thought we could use pgbouncer and in the case of the master being down our heartbeat script would reload the pgbouncer co

[GENERAL] HOT standby on windows not working

Hi All; We're setting up a HOT standby on Windows 2000 server and PostgreSQL 9.2 We do this: 1) stop both servers 2) copy the master data directory to the slave 3) edit the master postgresql.conf file as follows: Modify the following listen_address = ‘*’ wal_level = hot_standby max_wal_sender

[GENERAL] encrypting data stored in PostgreSQL

Hi All; We have a client with this requirement: At rest data must be encrypted with a unique client key Any thoughts on how to pull this off for PostgreSQL stored data? Thanks in advance -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscript

Re: [GENERAL] check constraint question

On 04/08/2014 04:08 PM, Rob Sargent wrote: On 04/08/2014 03:53 PM, CS_DBA wrote: On 04/08/2014 03:41 PM, Rob Sargent wrote: On 04/08/2014 03:36 PM, CS_DBA wrote: On 04/08/2014 03:31 PM, Rob Sargent wrote: On 04/08/2014 03:26 PM, CS_DBA wrote: On 04/08/2014 03:17 PM, Rob Sargent wrote

Re: [GENERAL] check constraint question

On 04/08/2014 03:41 PM, Rob Sargent wrote: On 04/08/2014 03:36 PM, CS_DBA wrote: On 04/08/2014 03:31 PM, Rob Sargent wrote: On 04/08/2014 03:26 PM, CS_DBA wrote: On 04/08/2014 03:17 PM, Rob Sargent wrote: On 04/08/2014 03:09 PM, CS_DBA wrote: On 04/08/2014 02:58 PM, Rob Sargent wrote

Re: [GENERAL] check constraint question

On 04/08/2014 03:31 PM, Rob Sargent wrote: On 04/08/2014 03:26 PM, CS_DBA wrote: On 04/08/2014 03:17 PM, Rob Sargent wrote: On 04/08/2014 03:09 PM, CS_DBA wrote: On 04/08/2014 02:58 PM, Rob Sargent wrote: On 04/08/2014 02:51 PM, CS_DBA wrote: Hi All we have a table like so: customer

Re: [GENERAL] check constraint question

On 04/08/2014 03:17 PM, Rob Sargent wrote: On 04/08/2014 03:09 PM, CS_DBA wrote: On 04/08/2014 02:58 PM, Rob Sargent wrote: On 04/08/2014 02:51 PM, CS_DBA wrote: Hi All we have a table like so: customer ( cust_id integer not null primary key, cust_group_id

Re: [GENERAL] check constraint question

On 04/08/2014 02:58 PM, Rob Sargent wrote: On 04/08/2014 02:51 PM, CS_DBA wrote: Hi All we have a table like so: customer ( cust_id integer not null primary key, cust_group_id integer not null, group_account_idinteger not null, cust_name

[GENERAL] check constraint question

Hi All we have a table like so: customer ( cust_id integer not null primary key, cust_group_id integer not null, group_account_idinteger not null, cust_name varchar not null, ... ) we want to force the cust_group_id to be unique across all group

[GENERAL] configure errors on Fedora 20

Hi All; when I try to compile postgresql 9.3.4 I get the below errors, anyone know if / which devel packages I need? Thanks in advance checking crypt.h usability... no checking crypt.h presence... yes configure: WARNING: crypt.h: present but cannot be compiled configure: WARNING: crypt.h: