Re: pg_ctl stop failure - Mailing list pgsql-novice

From Andreas Schmitz
Subject Re: pg_ctl stop failure
Date
Msg-id 519B967C.2060203@longimanus.net
Whole thread Raw
In response to Re: pg_ctl stop failure  ("Birchall, Austen" <austen.birchall@metoffice.gov.uk>)
Responses Re: pg_ctl stop failure  ("Birchall, Austen" <austen.birchall@metoffice.gov.uk>)
Changing listen_addresses  ("Birchall, Austen" <austen.birchall@metoffice.gov.uk>)
List pgsql-novice
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
offlineroute, 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@postgresql.org [mailto:pgsql-novice-owner@postgresql.org]
> Sent: 19 May 2013 10:20
> To: pgsql-novice@postgresql.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
>
>



pgsql-novice by date:

Previous
From: Michael Swierczek
Date:
Subject: Re: approach to logging complete statements
Next
From: "Birchall, Austen"
Date:
Subject: Re: pg_ctl stop failure