Re: broke postgres, how to fix?? - Mailing list pgsql-general

From Lonni J Friedman
Subject Re: broke postgres, how to fix??
Date
Msg-id CAP=oouGFkZQMAVJicq3=g2DRum7KqXutaQrOarxes1Tei6qaUQ@mail.gmail.com
Whole thread Raw
In response to broke postgres, how to fix??  (JD Wong <jdmswong@gmail.com>)
Responses Re: broke postgres, how to fix??
List pgsql-general
On Tue, Feb 26, 2013 at 4:10 PM, JD Wong <jdmswong@gmail.com> wrote:
> Hi Adrian,
>
>> That's guaranteed to break everything badly.
>
>
> Even if I "read only style" copied the files? Do you mind elaborating on why
> this happens?  ( or point me to relevant documentation )

What is "read only style", and how does postgres know about this?

http://www.postgresql.org/docs/9.2/static/backup-file.html


>
> Thanks,
> -JD
>
> On Tue, Feb 26, 2013 at 7:04 PM, Lonni J Friedman <netllama@gmail.com>
> wrote:
>>
>> On Tue, Feb 26, 2013 at 4:02 PM, JD Wong <jdmswong@gmail.com> wrote:
>> > Hi Adrian, yes I completely copied the config-file and data directories
>> > over.
>> >
>> > Lonnie, I don't remember.  I might not have shut down the "old"
>> > postgres,
>> > yes I set PGDATA accordingly.
>
>
>>
>>
>>
>> That's guaranteed to break everything badly.
>
>



--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman                                    netllama@gmail.com
LlamaLand                       https://netllama.linux-sxs.org

pgsql-general by date:

Previous
From: Lonni J Friedman
Date:
Subject: Re: broke postgres, how to fix??
Next
From: Adrian Klaver
Date:
Subject: Re: broke postgres, how to fix??