Re: [GENERAL] Starting new cluster from base backup

On 02/18/2015 01:48 PM, Guillaume Drolet wrote: So if I understand correctly you have: 1) On source machine a directory E:\Data\Database. 2) On the source machine in Postgres you have a created a tablespace that points at E:\Data\Database. 3) On destination machine you

Re: [GENERAL] Starting new cluster from base backup

2015-02-18 16:11 GMT-05:00 Adrian Klaver : > On 02/18/2015 11:51 AM, Guillaume Drolet wrote: > >> >> >> 2015-02-18 13:40 GMT-05:00 Adrian Klaver > >: >> >> On 02/18/2015 10:24 AM, Guillaume Drolet wrote: >> >> >> >> 2015-02-18 11:06 GMT-05:00 Adrian Kl

Re: [GENERAL] Starting new cluster from base backup

On 02/18/2015 11:51 AM, Guillaume Drolet wrote: 2015-02-18 13:40 GMT-05:00 Adrian Klaver mailto:adrian.kla...@aklaver.com>>: On 02/18/2015 10:24 AM, Guillaume Drolet wrote: 2015-02-18 11:06 GMT-05:00 Adrian Klaver mailto:adrian.kla...@aklaver.com>

Re: [GENERAL] Starting new cluster from base backup

2015-02-18 13:40 GMT-05:00 Adrian Klaver : > On 02/18/2015 10:24 AM, Guillaume Drolet wrote: > >> >> >> 2015-02-18 11:06 GMT-05:00 Adrian Klaver > >: >> >> > >> So is E:\ a network drive shared by both machines? >> >> >> No, E:\ is a local drive on which I cre

Re: [GENERAL] Starting new cluster from base backup

On 02/18/2015 10:24 AM, Guillaume Drolet wrote: 2015-02-18 11:06 GMT-05:00 Adrian Klaver mailto:adrian.kla...@aklaver.com>>: So is E:\ a network drive shared by both machines? No, E:\ is a local drive on which I created a tablespace, in order to have enough space for my database. In

Re: [GENERAL] Starting new cluster from base backup

2015-02-18 11:06 GMT-05:00 Adrian Klaver : > On 02/18/2015 04:26 AM, Guillaume Drolet wrote: > >> >> >> 2015-02-17 17:14 GMT-05:00 Adrian Klaver > >: >> >> >> On 02/17/2015 06:54 AM, Guillaume Drolet wrote: >> >> Adrian: thanks for this information. >>

Re: [GENERAL] Starting new cluster from base backup

On 02/18/2015 04:26 AM, Guillaume Drolet wrote: 2015-02-17 17:14 GMT-05:00 Adrian Klaver mailto:adrian.kla...@aklaver.com>>: On 02/17/2015 06:54 AM, Guillaume Drolet wrote: Adrian: thanks for this information. I tried running pg_basebackup in plain format with option -X s

Re: [GENERAL] Starting new cluster from base backup

2015-02-17 17:14 GMT-05:00 Adrian Klaver : > On 02/17/2015 06:54 AM, Guillaume Drolet wrote: > >> Adrian: thanks for this information. >> >> I tried running pg_basebackup in plain format with option -X stream >> (pg_basebackup -D "F:\208376PT\db" -X stream -l "208376PT17022015" -U >> postgres -P)

Re: [GENERAL] Starting new cluster from base backup

On 02/17/2015 06:54 AM, Guillaume Drolet wrote: Adrian: thanks for this information. I tried running pg_basebackup in plain format with option -X stream (pg_basebackup -D "F:\208376PT\db" -X stream -l "208376PT17022015" -U postgres -P) but I got the message: pg_basebackup: directory "E:\Data\Da

Re: [GENERAL] Starting new cluster from base backup

On 02/17/2015 06:54 AM, Guillaume Drolet wrote: Adrian: thanks for this information. I tried running pg_basebackup in plain format with option -X stream (pg_basebackup -D "F:\208376PT\db" -X stream -l "208376PT17022015" -U postgres -P) but I got the message: pg_basebackup: directory "E:\Data\Da

Re: [GENERAL] Starting new cluster from base backup

This provides part of the answer to my previous post, from the 9.4 doc (although I'm running 9.3 but I guess the second phrase in the paragraph applies to my case): Tablespaces will in plain format by default be backed up to the same path they have on the server, unless the option --tablespace-map

Re: [GENERAL] Starting new cluster from base backup

Adrian: thanks for this information. I tried running pg_basebackup in plain format with option -X stream (pg_basebackup -D "F:\208376PT\db" -X stream -l "208376PT17022015" -U postgres -P) but I got the message: pg_basebackup: directory "E:\Data\Database" exists but is not empty" I creatde a tabl

Re: [GENERAL] Starting new cluster from base backup

On 02/16/2015 11:31 AM, Guillaume Drolet wrote: Dear listers, I want to move a cluster from one machine to another. I used pg_basebackup to create an archive and copied/extracted it over the old PGDATA location on the new machine (the server was stopped). If I start pgsql I get these messages in

[GENERAL] Starting new cluster from base backup

Dear listers, I want to move a cluster from one machine to another. I used pg_basebackup to create an archive and copied/extracted it over the old PGDATA location on the new machine (the server was stopped). If I start pgsql I get these messages in my log file: 2015-02-16 14:29:12 EST LOG: datab