Re: [ADMIN] large database problems, solved?!

1999-03-08 Thread hal Lynch
>The table contains 22+ million records which are formatted so they >can be loaded using the psql copy command. Well I solved the problem. It turns out that I had a programmer (me) malfunction. My 22+ million record data had every other record containing only a single character, a newline. My

[ADMIN] deleting users

1999-03-08 Thread Don Seiler
Hullo. I'm not on this list, so could any replies also be sent to my email address? Thanks. My question is a fairly straightforward one. Say I have a user 'don'. I also have a user 'dseiler'. I just made 'dseiler'. 'don' however, owns all of the tables and indeces and such. I plan to use t

[ADMIN] db_dump... more info

1999-03-08 Thread Gerald Brandt
Hi there, I removed all of the indices from my database, and the error still occurs. -- dumping out the contents of Table gbr_mods -- dumping out the contents of Table gbr_prversion -- dumping out the contents of Table gbr_category -- reading indices information getIndices(): SELECT fail

Re: [ADMIN] failed db_dump

1999-03-08 Thread Terry Mackintosh
Hi Gerald Probably a currupt index? Try drop'ing some or all of the indexes, then dump and see if that helps. Terry On Mon, 8 Mar 1999, Gerald Brandt wrote: > Hmm, something went wrong... lets try this again... > > Hi there, > > I keep getting a failed db_dump, and I need to know why. I us

Re: [ADMIN] PostgreSQL 6.4.2 won't compile on Digital Unix V4.0d

1999-03-08 Thread Jan Kim
On Mon, Mar 08, 1999 at 03:07:09PM +0100, Reiner Dassing wrote: > Hello! > Thank you very much all of you who have given me some hints for solving > my problem of the compilation of PostgreSQL under Digital UNIX V4.0D > > Here are the steps of the successful compilation: > > 1. The option "-E" o

[ADMIN] [Fwd: postmaster crashing]

1999-03-08 Thread Doug Carter
Hi again, I sent this message out last week to this list and did not get any responses. Is this the correct list for this type of question? Is there another list that would be more appropriate? Thanks again, Doug Carter Doug Carter wrote: > > Hi all, > > I'm running a very small database wi

[ADMIN] failed db_dump

1999-03-08 Thread Gerald Brandt
Hmm, something went wrong... lets try this again... Hi there, I keep getting a failed db_dump, and I need to know why. I use this form backups. This is what I get when I try a dump (even after a vacuum)... -- dumping out the contents of Table pga_layout -- dumping out the contents of Table

[ADMIN] failed db_dump

1999-03-08 Thread Gerald Brandt
Hi there, I keep getting a failed db_dump, and I need to know why. I use this form backups. This is what I get when I try a dump (even after a vacuum)...

Re: [ADMIN] PostgreSQL 6.4.2 won't compile on Digital Unix V4.0d

1999-03-08 Thread Reiner Dassing
Hello! Thank you very much all of you who have given me some hints for solving my problem of the compilation of PostgreSQL under Digital UNIX V4.0D Here are the steps of the successful compilation: 1. The option "-E" of cc gave the hint that the preprocessor has deleted the const attribut of