[Linux-Biella] PgSQL

[Marco Barbera]

Avevo provato ma mi dava e continua a dare il seguente errore...

[root a marcof root]# pg_dumpall > db.out
pg_dumpall: query fallita: ERROR:  permesso negato per la relazione pg_shadow
pg_dumpall: la query è: SELECT usename, usesysid, passwd, usecreatedb, usesuper, valuntil FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database WHERE datname = 'template0')


  
= = = = = = = = = = = = = = = = = = = =
			
Marco Barbera
barbera a bilug.linux.it
2005-03-22


======= At 2005-03-22, 10.24.44 you wrote: =======

>On Tuesday 22 March 2005 10:22, Marco Barbera wrote:
>
>> Come faccio per risolvere questo problema?
>
>dal man:
>
>EXAMPLES
>       To dump all databases:
>
>       $ pg_dumpall > db.out
>
>
>       To reload this database use, for example:
>
>       $ psql -f db.out template1
>
>Anzi.. meglio il pg_dumpall -c
>
>-- 
>Cristiano Deana - FreeCRIS
>"Ho iniziato a usare FreeBSD perche' m$ usava me. ed e' spiacevole"
>[cris|crs] in irc su: irc.azzurra.org #freebsd-it #qmail-it
>_______________________________________________
>Linux mailing list
>Linux a ml.bilug.linux.it
>http://ml.bilug.linux.it/mailman/listinfo/linux
>