Alain Roger wrote: > i backup my database "sewe" using a standard process. > 1. it backups only database and not roles :-( roles are backuped separately. > 2. backup is a tar file > 3. backup command is : pg_dump -v -o -U myuser -ci -Ft -f sewe.tar sewe > > Question > how can i restore it now ? > could something like that could work on Windows XP ? > createdb sewe > gunzip -c sewe.tar | psql sewe Something like pg_restore -Ft sewe.tar Yours, Laurenz Albe
