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.

I copy the whole folder 'Data' to another PC where fresh postgresql
8.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...

any clue?

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,
itsD:\Postgres\8.4\data
but of course, your mileage may vary.

On Thu, Mar 24, 2011 at 12:07 PM, Waqar Azeem
<waqarazeem.private@gmail.com>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.

--
Thanks & Best Regards,
Waqar Azeem

--
Thanks & Best Regards,
Waqar Azeem

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

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?

On Thu, Mar 24, 2011 at 4:31 PM, Waqar Azeem
<waqarazeem.private@gmail.com>wrote:

I copy the whole folder 'Data' to another PC where fresh postgresql 8.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...

any clue?

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, itsD:\Postgres\8.4\data
but of course, your mileage may vary.

On Thu, Mar 24, 2011 at 12:07 PM, Waqar Azeem <
waqarazeem.private@gmail.com> 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.

--
Thanks & Best Regards,
Waqar Azeem

--
Thanks & Best Regards,
Waqar Azeem

--
Thanks & Best Regards,
Waqar Azeem

Thanks Karsten n' Raymond,

Finally, I change the logging in account to Local System account as
suggested in your URL. And then change it back to .\postgres
This magically worked for me.

I think ctrl+alt+del was a compulsory part of XP trouble shootings :)

-- Waqar

On Thu, Mar 24, 2011 at 5:10 PM, Waqar Azeem
<waqarazeem.private@gmail.com>wrote:

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?

On Thu, Mar 24, 2011 at 4:31 PM, Waqar Azeem <waqarazeem.private@gmail.com

wrote:

I copy the whole folder 'Data' to another PC where fresh postgresql 8.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...

any clue?

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, itsD:\Postgres\8.4\data
but of course, your mileage may vary.

On Thu, Mar 24, 2011 at 12:07 PM, Waqar Azeem <
waqarazeem.private@gmail.com> 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.

--
Thanks & Best Regards,
Waqar Azeem

--
Thanks & Best Regards,
Waqar Azeem

--
Thanks & Best Regards,
Waqar Azeem

--
Thanks & Best Regards,
Waqar Azeem

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