Обсуждение: Database recovery.

On 03/24/11 12:07 AM, Waqar Azeem wrote:
> My XP is crashed and now I have to take a full backup of my postgresql
> 8.4
>
> I am used to get backup of ldf/mdf files in case of SQLServer
>
> Please let me know the right way of doing this for postgresql 8.4.
>

you need everything in the $PGDATA directory.     On my system here, its
D:\Postgres\8.4\data  but of course, your mileage may vary.

On Thu, Mar 24, 2011 at 04:31:19PM +0500, Waqar Azeem wrote:

> The postgresql-8.4 - PostgreSQL Server 8.4 service could not be started.
>
> The service did not report an error.
>
> More help is available by typing NET HELPMSG 3534.
>
> The start command returned an error (2)
>
> Press <return> to continue...
>
>
> any clue?

Hmmm. So, what's the output of running

    NET HELPMSG 3534

?

Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

On 24/03/2011 11:31, Waqar Azeem wrote:
> I copy the whole folder'Data'  to another PC where freshpostgresql8.4
> is installed (same as default config. that previous version have
> had)
>
> when i started the server got following ...
>
> The postgresql-8.4 - PostgreSQL Server 8.4 service could not be
> started.
> The service did not report an error.
> More help is available by typing NET HELPMSG 3534.
> The start command returned an error (2)
> Press<return>  to continue...

Have a look in the Postgres log - there's often (usually?) information
there that doesn't get sent to the Windows event log.

It's probably in $PGDATA/pg_log, unless you changed something in the
logging configuration.

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

On Thu, Mar 24, 2011 at 12:37:25PM +0100, Karsten Hilbert wrote:

> > More help is available by typing NET HELPMSG 3534.

...

> > any clue?

And the second Google result has this:

    http://archives.postgresql.org/pgsql-bugs/2009-05/msg00005.php

Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

Waqar,

> my windows event viewer says:
> 2011-03-24 11:24:22 GMT FATAL:  could not create lock file "postmaster.pid":
> Permission denied
> is this helpfull?

yes. that says that the windows-user your PostgreSQL Service is
running as has no write priv on the data directory. Check your file
systems permissions and allow writing to the data directory for the
user your PostgreSQL service runs as.

Best wishes

HArald





--
Harald Armin Massa     www.2ndQuadrant.com
PostgreSQL  Training, Services  and Support

2ndQuadrant Deutschland GmbH
GF: Harald Armin Massa
Amtsgericht Stuttgart, HRB 736399

On 2011-03-24, Waqar Azeem <waqarazeem.private@gmail.com> wrote:
> --0015174766a0ffbf86049f35206e
> Content-Type: text/plain; charset=ISO-8859-1
>
> My XP is crashed and now I have to take a full backup of my postgresql 8.4
>
> I am used to get backup of ldf/mdf files in case of SQLServer
>
> Please let me know the right way of doing this for postgresql 8.4.

You need the data directory, and the service user "postgres" needs to
own it's contents.   consider using runas and xcopy.

--
⚂⚃ 100% natural