Re: how to recover database back from /data folder [ Possibly

From: "Andy Shellam (Mailing Lists)" <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: how to recover database back from /data folder [ Possibly
Date: 2006-12-11 14:11:59
Message-ID: 457D672F.5060302@mailnetwork.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


> I think the above messages support the fact that the database was
> shutdown
> properly before the filesystem level backup.
> Can anyone kindly confirm it ?
"LOG: database system is ready"

Says it all - if it hadn't been, you'd have gotten "LOG: database system
was not shut-down cleanly, recovering" or along those lines.
>
> I listed the tables and did some selects the data seems to be there.
> I think postgres was not starting for some peripheral issues
> not because that data folder was corrupted.
>
> BTW
> when i first started postmaster it gave an error related to
> too liberal permissions. Probably the original poster was doing
> the same mistake.
>
> Regds
> mallah.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
> !DSPAM:37,457d667230861609539772!
>
>

--
Andy Shellam
NetServe Support Team

the Mail Network
"an alternative in a standardised world"

p: +44 (0) 121 288 0832/0839
m: +44 (0) 7818 000834

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Shoaib Mir 2006-12-11 14:45:07 Re: how to recover database back from /data folder [ Possibly Recovered ]
Previous Message Rajesh Kumar Mallah 2006-12-11 14:07:41 Re: how to recover database back from /data folder [ Possibly Recovered ]