Re: [GENERAL] Re: Re: [GENERAL] PostgreSQL mirroring from RPM install to Source install

2016-12-19 Thread John R Pierce
On 12/15/2016 2:16 PM, Richard Brosnahan wrote: gdb is not available on this machine. Neither which or locate could find it. The servers we're given are truly, shockingly, stripped down models. what OS is this, what compiler toolchain did you use to build postgres on them? -- john r pie

Re: [GENERAL] PostgreSQL mirroring from RPM install to Source install

2016-12-19 Thread marica.fr
On Thu, 15 Dec 2016 16:42:13 + (GMT) Richard Brosnahan wrote: > > I get a checksum error, from pg_ctl. > 2016-12-15 08:27:14.520 PST >FATAL: incorrect checksum in control file > Hi Richard, Not sure if it applies, but just in case, I got this error when trying to use a cluster copied fr

[GENERAL] Re: Re: [GENERAL] PostgreSQL mirroring from RPM install to Source install

2016-12-19 Thread Richard Brosnahan
gdb is not available on this machine. Neither which or locate could find it. The servers we're given are truly, shockingly, stripped down models.  At this point, I believe my best course of action is to twist some sys admin arms and get a properly installed PostgreSQL on this machine. Even if

[GENERAL] Re: [GENERAL] PostgreSQL mirroring from RPM install to Source install

2016-12-19 Thread Richard Brosnahan
The slave: $ pg_controldata --version pg_controldata (PostgreSQL) 9.4.1 $ echo $PGDATA /apps/database/postgresql-data $ pg_controldata $PGDATA WARNING: Calculated CRC checksum does not match value stored in file. Either the file is corrupt, or it has a different layout than this program is expecti

Re: [GENERAL] PostgreSQL mirroring from RPM install to Source install

2016-12-16 Thread Vincent Veyron
[re-post, originally sent with wrong username] On Thu, 15 Dec 2016 16:42:13 + (GMT) Richard Brosnahan wrote: > > I get a checksum error, from pg_ctl. > 2016-12-15 08:27:14.520 PST >FATAL: incorrect checksum in control file > Hi Richard, Not sure if it applies, but just in case, I got th

Re: [GENERAL] Re: [GENERAL] PostgreSQL mirroring from RPM install to Source install

2016-12-15 Thread Tom Lane
Richard Brosnahan =?utf-8?B?UmU6IFtHRU5FUkFMXSBQb3N0Z3JlU1FMIG1pcnJvcmluZyBmcm9tIFJQTSBp?= =?utf-8?B?bnN0YWxsIHRvIFNvdXJjZSBpbnN0YWxs?= writes: > The slave: > $ pg_controldata --version > pg_controldata (PostgreSQL) 9.4.1 > $ echo $PGDATA > /apps/database/postgresql-data > $ pg_controldata $PGDA

Re: [GENERAL] PostgreSQL mirroring from RPM install to Source install

2016-12-15 Thread Tom Lane
Richard Brosnahan writes: > I've got a PostgreSQL database server version 9.4.1 installed on an OEL 6 > server. I have a second PostgreSQL database server version 9.4.1 running on > an identical OEL 6 server. The first PostgreSQL was installed by system > admins using RPM. The second PostgreSQL

[GENERAL] PostgreSQL mirroring from RPM install to Source install

2016-12-15 Thread Richard Brosnahan
Good day to you! I've got a PostgreSQL database server version 9.4.1 installed on an OEL 6 server. I have a second PostgreSQL database server version 9.4.1 running on an identical OEL 6 server. The first PostgreSQL was installed by system admins using RPM. The second PostgreSQL was installed f