[GENERAL] Re: Restore from a dead machine.

Make sure that the user running the script has read perms on the Pg.pm file. -- Alex Howansky Wankwood Associates http://www.wankwood.com/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] Re: php Compile question

> This has been discussed quite a few times recently (in fact, I posted a > similar reply yesterday). From Tom Lane: > > "Change php_pgsql.h to refer to postgres_fe.h not postgres.h." ... or symlink postgres.h to postgres_fe.h ... -- Alex Howansky Wankwood Associates h

[GENERAL] Re: Logging Queries

> Is there any way to have the server log the queries that are coming in so I > can see what's actually getting processed? Start the postmaster with "-d 2" on the command line. -- Alex Howansky Wankwood Associates http://www.wankwood.com/ ---

[GENERAL] Re: Re: Fast Inserts and Hardware Questions

-5 configuration would be faster than a $98 IDE drive... > Have you tried 7.1b5 on the big box? Not yet, I'm waiting for a quiet weekend. I'll post my stats when (if...) I get around to doing that. -- Alex Howansky Wankwood Associates http://www.wankwood.com/

[GENERAL] error logging

one bad line of code. Is there a debug level that will only output the text of the queries if they fail? Level 1 doesn't give me any queries, and level 2 gives me all of them... -- Alex Howansky Wankwood Associates http://www.wankwood.com/ ---(end of broadcast)---

Re: [GENERAL] "critical mass" reached?

crashing, we want to get some core > files so we can see what's happening. Ok, will verify. Thanks. -- Alex Howansky Wankwood Associates http://www.wankwood.com/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the

[GENERAL] Re: "critical mass" reached?

records in your log-table? We haven't got that far yet. I was hoping to get some other ideas prior to doing something so drastic, but we'll try it ... > Six million _tables_ is a lot, but you're right 6M records is pretty small > compared to what some people are using.

[GENERAL] how to determine what a process is doing

-- but it could be any one of a few hundred different queries. Is there any way to determine exactly what a postgres process is doing at any time? The output from the ps command only shows "INSERT" or "SELECT", and not the full query string. TIA, -- Alex Howansky Wankwood Associates http://www.wankwood.com/