Time Machine Restore - Empty Postgres Databases

Thank you, i found this page when searching for my problem, but the site only talks about restoring single databases in single files. I seem to have all 5 databases in one file (dumpall.psql) and so i dont know how to restore them.

Can you help me with this please?

Ok, i'm at least some steps closer:

I have my data back in postgre and all users have their data back on their devices. At least their data up to the last backup.

Here is what i did:

1. I restored another time machine backup.
2. Apple claims, that serverbackup (and therefore Time Machine) does backups of the postgre data, which is true.
3. Apple claims, that the postgre data will be restored in case of a Time Machine restore. In my case it didnt.
4. You find a dumpall.psql in your time machine backups --> Library/Server/PostgreSQL/Backup (In my case there was a gzip file as well, but it didnt seem to be updated)
5. I connected with postgre using pgadmin 3 following this tutorial: http://www.mactasia.co.uk/revisited-using-postgresql-in-lion-server
6. I dropped all databases but the postgres-database.
7. Open Terminal and write "sudo psql -f infile postgres" with infile being the path to your dumpall.psql (More commands at http://www.postgresql.org/docs/8.1/interactive/backup.html)
8. This will write all data from the backup to your database.
9. Voilá, you will have your data back.
10. Give the clients time to get the content back from the server.
11. Never start the wiki again, because it was the one which destroyed everything in the first place.

Still i have a huge problem:

I cant login with my main admin user. I can login with another admin. Then i reset the main user password and i can login with it again. But only once. Any advice on this?

The error log says:

servername SecurityAgent[722]: Unknown user "adminuser" login attempt PASSED for auditing

Making progress:

Now i can login again. This is what i did:

1. Open Server Admin
2. Go to the "Access" tab
3. In the left panel click on "Login Window"
4. Click the little "+" button at the bottom and add the group "administrators" via drag and drop to the allowed list.
5. Check if it worked with login out and in again.