Re: [GENERAL] [ADMIN] Fast Deletion For Large Tables

2002-10-08 Thread Shridhar Daithankar
On 5 Oct 2002 at 20:17, Nikolaus Dilger wrote: > Partitioned tables would solve your issue since you > could just truncate a partiotion in order to delete the > unneeded data. Unfortunately they are not available in > PostgreSQL. But maybe in a future release. If you don't mind realigning your

Re: [ADMIN] Debug information

2002-10-08 Thread POLONIUM-Team
Hallo, I found in reference.pdf small part about debug level. Where can I read more about the 17 debug levels? Best Regards, Rafal At 18:06 07.10.2002 -0500, Devinder K Rajput wrote: >You can display a lot of debug info setting up loggin. Make the following >changes in your postgresql.conf

[ADMIN] Two questions.

2002-10-08 Thread bon
Hello ! Where I can find information, to know since one is organized the system of files of a PostgreSQL database ? ( files of database objects ). If I have a " disc crash " or lose accidental one or several files, since I can realize which lack? Thank you very much. Fabio Bon --

[ADMIN] pg_dump command inside shell scripts

2002-10-08 Thread Elielson Fontanezi
Hi Folks! Again I need a help from you! I have develop a shell script (seen below) to do dump and vaccum automatically. Once pg_dump command prompts for password, I changed the $PGDATA/*hba.conf file to identify Linux user which starts the shell script to avoid password prompt. But n

Re: [ADMIN] pg_dump command inside shell scripts

2002-10-08 Thread David F. Skoll
On Tue, 8 Oct 2002, Elielson Fontanezi wrote: > to identify Linux user which starts the shell script to avoid password > prompt. There's a virtually-undocmented environment variable: PGPASSWORD PGPASSWORD="secret-password" export PGPASSWORD # Now pg_dump will not prompt

Re: [ADMIN] problems with pltcl.so

2002-10-08 Thread Tom Lane
"Josh Goldberg" <[EMAIL PROTECTED]> writes: > ERROR: Load of file /home/postgres/lib/pltcl.so failed: dlopen '/home/post= > gres/lib/pltcl.so' failed. (Shared object "libtcl80.so.1" not found) > I am on freebsd 4.4, I have libtcl80.so.1 in /usr/local/lib and not only is= > it in my ld-elf.so.hi

Re: [ADMIN] Debug information

2002-10-08 Thread Bruce Momjian
POLONIUM-Team wrote: > Hallo, > > I found in reference.pdf small part about debug level. Where can I read > more about the 17 debug levels? The levels are really only 1-5, and they just represent increasing amounts of detail. -- Bruce Momjian| http://candle.pha.pa.u

[ADMIN] Two questions.

2002-10-08 Thread Fabio C. Bon
Hello ! Where I can find information, to know since one is organized the system of files of a PostgreSQL database ? ( files of database objects ). If I have a " disc crash " or lose accidental one or several files, since I can realize which lack? Thank you very much. Fabio Bon ---

[ADMIN] phpPgAdmin + PostgreSQL + authentication

2002-10-08 Thread Johnson, Shaunn
Title: phpPgAdmin + PostgreSQL + authentication Howdy: Not sure if this the most likely of maillists to ask, but is anyone using phpPgAdmin?  I have a few questions regarding authentication of username / passwords. I'm running PostgreSQL 7.2.1 on RedHat Linux 7.2 kernel 2.4.7-10. I have

[ADMIN] Two questions.

2002-10-08 Thread bon
Sorry about my previous message. It wasn't clear. Where can I find information about how the system of files of a PostgreSQL database is organized ? ( files of database objects ). If I have a " disc crash " or I lose accidentally one or several files, how can I realize which are lacking ? Than

Re: [ADMIN] problems with pltcl.so

2002-10-08 Thread Josh Goldberg
my goodness that didn't even brush past my mind! thanks much for the assist! :) - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Josh Goldberg" <[EMAIL PROTECTED]> Cc: "postgres-admin" <[EMAIL PROTECTED]> Sent: Tuesday, October 08, 2002 6:50 AM Subject: Re: [ADMIN] problems w

Re: [ADMIN] problems with pltcl.so

2002-10-08 Thread Josh Goldberg
It was listed in the ldconfig hints file, but adding LD_LIBRARY_PATH to the postmaster's login environment explicitly did the trick. - Original Message - From: "Chad R. Larson" <[EMAIL PROTECTED]> To: "Tom Lane" <[EMAIL PROTECTED]>; "Josh Goldberg" <[EMAIL PROTECTED]> Cc: "postgres-admin"

Re: [ADMIN] PostgreSQL and 2-node failover cluster solutions

2002-10-08 Thread Chris Miles
On Sun, Oct 06, 2002 at 03:21:14PM +0200, Ragnar Kjørstad wrote: > Well; if you have a single NetApp then you still have a single point of > failure (avoiding that is the whole purpose of failover, right?), and if > you have two of them then it's one pretty damn expensive > postgresql-server :) I

Re: [ADMIN] Two questions.

2002-10-08 Thread Bruce Momjian
[EMAIL PROTECTED] wrote: > Hello ! > > Where I can find information, to know since one is organized the system of > files of a PostgreSQL database ? ( files of database objects ). > > If I have a " disc crash " or lose accidental one or several files, since I > can realize which lack? I wrote s