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
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 ] |