From: | "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk> |
---|---|
To: | Andreas Schmitz <mailinglist(at)longimanus(dot)net> |
Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: pg_ctl stop failure |
Date: | 2013-05-22 10:31:47 |
Message-ID: | 4E154FB60786D74BB4DFDC97BF991CAC050D9A@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
As
show archive_command;
archive_command
-----------------
(disabled)
(1 row)
Doesn't this mean that I can't use pg_start_backup but something to keep in mind for the future
Thanks
Austen
-----Original Message-----
From: Andreas Schmitz [mailto:mailinglist(at)longimanus(dot)net]
Sent: 21 May 2013 16:45
To: Birchall, Austen
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] pg_ctl stop failure
There is no need for a restore. The online copy is a snapshot of the cluster dir and can be used like an offline copy. The advantage is that no databases and backend processes need to be terminated.
regards
Andreas
On 05/20/2013 11:57 AM, Birchall, Austen wrote:
> Hi Andreas
>
> Due to permissions associated with the ESRI 'system' user even in 9.* you can't do a simple restore from an online backup - you have to restore public first- for 8.3 I have unable to get this solution to work hence going down the offline route, which is actually not an issue as regards downtime for the particular databases I am working on at present.
>
> Austen
>
> -----Original Message-----
> From: pgsql-novice-owner(at)postgresql(dot)org
> [mailto:pgsql-novice-owner(at)postgresql(dot)org]
> Sent: 19 May 2013 10:20
> To: pgsql-novice(at)postgresql(dot)org
> Subject: [pgsql-novice] Daily digest v1.3342 (1 messages)
>
> Message Digest
> Volume 1 : Issue 3342 : "mime" Format
>
> Messages in this Issue:
> Re: pg_ctl stop failure
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Schmitz | 2013-05-22 16:52:07 | Re: pg_ctl stop failure |
Previous Message | Andreas Schmitz | 2013-05-21 15:45:00 | Re: pg_ctl stop failure |