Dear Postgres!
Sorry my bad English first.
I'm found a bug in the PSQL 8 Beta2 Devel 3, and 7.4.x (x=2,3,4,5) too: - The PSQL 8 is working on Win XP. - The PSQL 7.4.x is working on SuSE and Yoper Linux distros.
I have 8900 users is in 4 group.
1. I'm maked a 'pg_dumpall -c >full_dump.sql'
2. I make a 'psql -f full_dump.sql template1 postgres'
3. After finished the users in the full_dump.sql, the PostgreSQL service is broken.
I'm fix it with the following:
1. I'm maked a 'users.sql' file with cuted user creation section from full_dump.sql
2. I'm maked a 'data.sql' file with cuted data creation section from full_dump.sql
3. 'psql -f users.ql template1 postgres'
4. 'psql -f data.ql template1 postgres'
Best Regards: Ferenc Lutischan from Hungary
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html