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

Reply via email to