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