Re: pg_ctl stop failure

From: "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: pg_ctl stop failure
Date: 2013-05-20 09:57:18
Message-ID: 4E154FB60786D74BB4DFDC97BF991CAC04F917@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Swierczek 2013-05-20 18:18:27 approach to logging complete statements
Previous Message Birchall, Austen 2013-05-20 09:48:08 Re: pg_ctl stop failure