auch, postgresql

Gordon Messmer yinyang at eburg.com
Tue Apr 11 22:22:13 UTC 2006


Marcel Janssen wrote:
> 
> Well, I managed to start the old postgresql, but I can't backup :
> 
> $ pg_dumpall > postgresql_fc4_data
> pg_dumpall: could not connect to database "template1": FATAL:  user "root" 
> does not exist

The default configuration uses ident authentication, so you should use 
the postgres user to perform your backup:

# su postgres -c pg_dumpall > postgresql_fc4_data




More information about the users mailing list