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
WALmode early on. 

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

Austen

-----Original Message-----
From: Andreas Schmitz [mailto:mailinglist@longimanus.net]
Sent: 22 May 2013 18:20
To: Birchall, Austen
Cc: pgsql-novice@postgresql.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@longimanus.net]
> Sent: 21 May 2013 16:45
> To: Birchall, Austen
> Cc: pgsql-novice@postgresql.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
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
>>
>>