Thread:

On 5 Aug 2006 at 19:32, luciano wrote:

> I stop the postmaster service and then i copy the directory in an
> other place. Restart the postmaster and then test someting
> modifications. Then i stop the service and restore the saved data
> directory Now the postmaster dont start any more

The recommended method for backing up & restoring a database cluster
is to use pg_dump:

http://www.postgresql.org/docs/8.1/static/app-pgdump.html

--Ray.


----------------------------------------------------------------------

Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, Ireland
rod@iol.ie
----------------------------------------------------------------------

# luciano@craem.com / 2006-08-05 19:32:27 +0200:
> I stop the postmaster service and then i copy the directory in an other place.
> Restart the postmaster and then test someting modifications.
> Then i stop the service and restore the saved data directory
> Now the postmaster dont start any more
> Wy?

    I'd guess you didn't preserve permissions on the data directory
    contents. What does PostgreSQL log?

--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991