Questions about PostgreSQL backup/restores I've inherited a large PostgreSQL 8.4.7 database that is currently not being backup at all.  The database itself I believe is around 100GB, I've been reading about the different methods to backup this type of DB here

My questions are: 

1) Typically how fast or slow is the pg_dump dump process?  I know its a subjective question and depends on hardware and the database, but roughly 100gb can I expect this to take 1 hour, 12 hours, 24+?  I'd like to set an expectation with management and users before I begin.

2) The restore instructions indicate the following:

Before restoring a SQL dump, all the users who own objects or were granted permissions on objects in the dumped database must already exist. If they do not, then the restore will fail to recreate the objects with the original ownership and/or permissions.


Is it possible to gather this information as part of the backup?  Or is there a separate backup process for users and permissions?  Because I'm inheriting this database, Im not sure about all the users and permissions yet and would like to just backup everything for offsite storage.
2) pg_dumpall is what you're looking for if you want all objects (globals, roles, etc.). 

1) You noted that it is subjective. On my dev laptop (Win7 x64 .. i7 4 @ 2.2 ... 12 GB RAM ... normal, spinny disk @ 5400) I backup a 4GB pg cluster in about 15 seconds. I don't know if it scales linearly. 

Finally, depending on your OS, I'd verify that it's not actually being backed up. I've seen pg on linux being backed up at the file system level using rsync. Without getting into a debate about the relative merits of these differing methods, I'd verify that this isn't already implemented.