Re: pg_ctl stop failure

Actually

Apart from semi-regular bulb data loads these databases are pretty much static so I decided not to go into archiving WAL mode early on.

Thanks for your help though, as I said perhaps something for the future

Austen

-----Original Message-----
From: Andreas Schmitz [mailto:mailinglist(at)longimanus(dot)net]
Sent: 22 May 2013 18:20
To: Birchall, Austen
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] pg_ctl stop failure

And the archive_mode has to be set to on specifying an archive_command in postgresql.conf

refer to

http://www.postgresql.org/docs/8.3/static/continuous-archiving.html

On 05/22/2013 12:31 PM, Birchall, Austen wrote:
> 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
>>
>>