Re: pg_update to a new machine?

2018-02-24 Thread Ron Johnson
On 02/24/2018 06:40 PM, Stephen Frost wrote: Ron, * Ron Johnson (ron.l.john...@cox.net) wrote: On 02/24/2018 03:10 PM, Stephen Frost wrote: [snip] To set up log shipping on 8.4, I do this, which works well: select pg_start_backup('some_meaningful_tag'); nohup rsync -avz /var/lib/pgsql/data/*

Re: pg_update to a new machine?

2018-02-24 Thread Stephen Frost
Ron, * Ron Johnson (ron.l.john...@cox.net) wrote: > On 02/24/2018 03:10 PM, Stephen Frost wrote: > [snip] > >>To set up log shipping on 8.4, I do this, which works well: > >> > >>select pg_start_backup('some_meaningful_tag'); > >>nohup rsync -avz /var/lib/pgsql/data/* > >>postgres@${DESTIP}:/var/

Re: pg_update to a new machine?

2018-02-24 Thread Ron Johnson
On 02/24/2018 03:10 PM, Stephen Frost wrote: [snip] To set up log shipping on 8.4, I do this, which works well: select pg_start_backup('some_meaningful_tag'); nohup rsync -avz /var/lib/pgsql/data/* postgres@${DESTIP}:/var/lib/pgsql/data/ & select pg_stop_backup(); That's not log shipping, for l

Re: pg_update to a new machine?

2018-02-24 Thread Stephen Frost
Greetings, * Ron Johnson (ron.l.john...@cox.net) wrote: > On 02/24/2018 08:18 AM, Stephen Frost wrote: > >* Ron Johnson (ron.l.john...@cox.net) wrote: > >>2. install 8.4 on the new server, > >>3. install 9.6.6 on the new server, > >For pg_upgrade, you do need both versions installed on the server

Re: extract properties from certificates

2018-02-24 Thread jotpe
Am 24.02.2018 um 16:58 schrieb Tom Lane: jotpe writes: I found the pg-cert extension at https://github.com/beargiles/pg-cert I have trouble to compile it. When I enter "make" following error message appears: Makefile:29: /usr/lib/postgresql/9.6/lib/pgxs/src/makefiles/pgxs.mk: Datei oder Verze

Re: extract properties from certificates

2018-02-24 Thread Tom Lane
jotpe writes: > I found the pg-cert extension at https://github.com/beargiles/pg-cert > I have trouble to compile it. When I enter "make" following error > message appears: > Makefile:29: /usr/lib/postgresql/9.6/lib/pgxs/src/makefiles/pgxs.mk: > Datei oder Verzeichnis nicht gefunden > make: ***

Re: pg_update to a new machine?

2018-02-24 Thread Ron Johnson
On 02/24/2018 08:18 AM, Stephen Frost wrote: Greetings, * Ron Johnson (ron.l.john...@cox.net) wrote: The 2.8TB database must be moved to a new server in a new Data Center, and upgraded from 8.4.17 to 9.6.6 Will this work? pg_upgrade --old-datadir "CURSERVER://var/lib/pgsql/data"

extract properties from certificates

2018-02-24 Thread jotpe
Hello, I want to extract properties from x.509 certificates stored in a bytea column. I found the pg-cert extension at https://github.com/beargiles/pg-cert I have trouble to compile it. When I enter "make" following error message appears: Makefile:29: /usr/lib/postgresql/9.6/lib/pgxs/src/ma

Re: pg_update to a new machine?

2018-02-24 Thread Stephen Frost
Greetings, * Ron Johnson (ron.l.john...@cox.net) wrote: > The 2.8TB database must be moved to a new server in a new Data Center, and > upgraded from 8.4.17 to 9.6.6 > > Will this work? > > pg_upgrade > --old-datadir "CURSERVER://var/lib/pgsql/data" > --new-datadir "NEWSERVER://va

Re: pg_update to a new machine?

2018-02-24 Thread Andreas Kretschmer
Am 24.02.2018 um 04:57 schrieb Ron Johnson: The 2.8TB database must be moved to a new server in a new Data Center, and upgraded from 8.4.17 to 9.6.6 Will this work? pg_upgrade --old-datadir "CURSERVER://var/lib/pgsql/data" --new-datadir "NEWSERVER://var/lib/pgsql/data"