[ADMIN] Speed problem

1998-11-03 Thread Roger Books
I have a database that I need to pull the schema off of. When I run pg_dump -s the machine rolls over and dies. To the tune of I left it running over the weekend and still had 98% cpu usage by postgress monday. I managed to do a 'delete from statistics' and it accomplished this overnight, but w

[ADMIN] extensions to pg_user

1998-11-03 Thread Lorenzo Huerta
Is there a way to extend features of pg_user file to handle another field in there for group_names? See i want to set up security on a database such that when a person tries to authenticate on the web i want to compare their id,passwd with what i have for them in pg_user and if they are authentic

Re: [ADMIN] Speed problem

1998-11-03 Thread The Hermit Hacker
On Tue, 3 Nov 1998, Roger Books wrote: > I have a database that I need to pull the schema off of. When > I run pg_dump -s the machine rolls over and dies. To the tune > of I left it running over the weekend and still had 98% cpu > usage by postgress monday. I managed to do a 'delete from stati