Re: [ADMIN] vaccumdb is giving "ERROR: out of free buffers: time to abort !"

2003-01-08 Thread Raja Kumar Thatte
Hai Tom Lane Thanks a lot. I think I have to increase shared_buffers. I will try. I think this will solve my problem c u raja --- Tom Lane <[EMAIL PROTECTED]> wrote: > Raja Kumar Thatte <[EMAIL PROTECTED]> writes: > > After 7 to 8 hours I am getting > > ERROR: out of free buffers: time to abort

[ADMIN] HowTo TOAD and PostgreSQL???

2003-01-08 Thread [EMAIL PROTECTED]
TOAD and Oracle is a somewhat popular combination. Has anyone ever gotten TOAD to connect with PostgreSQL? Does it do it at all? If so, how? TIA. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -

Re: [ADMIN] Perl Pg interface to Postgresql

2003-01-08 Thread Bruce Momjian
See gborg.postgresql.org under interfaces. We moved them over there. --- Hal Lynch wrote: > In postgresql-7.2.1 the Perl Pg interface was found in > src/interfaces/perl5. > In postgresql--7.3 there is no src/interfaces/per

[ADMIN] Perl Pg interface to Postgresql

2003-01-08 Thread Hal Lynch
In postgresql-7.2.1 the Perl Pg interface was found in src/interfaces/perl5. In postgresql--7.3 there is no src/interfaces/perl5. What gives? I have something like 100+ perl scripts which use the Pg interface so as you can imagine I am disappointed!? Anybody have a clue what happened? hal --

[ADMIN] problem with authentication

2003-01-08 Thread Justin Georgeson
I have a dump file I created with pg_dumpall on a 7.0.3 installation. I'm trying to run 'psql < dumpall.dmp' on a 7.2.3 installation. I set local connections for all databases to trust in pg_hba.conf, but I'm still asked for a password. I only have local connection open (tcpip_socket is set to

Re: [ADMIN] Find out configure options used on install

2003-01-08 Thread Tom Lane
"Bryan Encina" <[EMAIL PROTECTED]> writes: > I was just wondering if there was an easy/standard way of finding out what > configure options were used on installation (either from source or rpm). pg_config --configure If you haven't got pg_config, you're overdue for an upgrade.

Re: [ADMIN] Increase max_connections

2003-01-08 Thread Gaetano Mendola
I seen, but I was hopping till now that was not true! :-( Ciao Gaetano. "Tom Lane" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > "Gaetano Mendola" <[EMAIL PROTECTED]> writes: > > is it possible increase the max_connections value without > > restarting the s

Re: [ADMIN] Increase max_connections

2003-01-08 Thread Tom Lane
"Gaetano Mendola" <[EMAIL PROTECTED]> writes: > is it possible increase the max_connections value without > restarting the server ? Nope, sorry. This *is* documented btw. MAX_CONNECTIONS (integer) Determines the maximum number of concurrent connections to the database server. The default

Re: [ADMIN] vaccumdb is giving "ERROR: out of free buffers: time to abort !"

2003-01-08 Thread Tom Lane
Raja Kumar Thatte <[EMAIL PROTECTED]> writes: > After 7 to 8 hours I am getting > ERROR: out of free buffers: time to abort ! > vacuumdb: vacuum xyzdb failed What do you have shared_buffers set to? If it's still the default (64), that's way too small for a production installation. Try a few th

[ADMIN] repair table? database? how ? neccessary?

2003-01-08 Thread David Gilbert
> "mitchell" == mitchell laks <[EMAIL PROTECTED]> writes: mitchell> The main issue I had with Access was that as the database mitchell> got larger, My application began to fail regularly, and I mitchell> began to need to do "repair" of the database almost on a mitchell> daily or other daily ba

Re: [ADMIN] Find out configure options used on install

2003-01-08 Thread Adam Witney
If compiled from source you can find the configure options used in config.status, not sure about with the rpm though adam > I was just wondering if there was an easy/standard way of finding out what > configure options were used on installation (either from source or rpm). > Any help would be g

[ADMIN] Find out configure options used on install

2003-01-08 Thread Bryan Encina
I was just wondering if there was an easy/standard way of finding out what configure options were used on installation (either from source or rpm). Any help would be greatly appreciated. Thanks, -B ---(end of broadcast)--- TIP 2: you can get off all

Re: [ADMIN] Increase max_connections

2003-01-08 Thread Devinder K Rajput
you could do a "kill -SIGHUP postmaster_pid".  This will tell postmaster to re-read the configuration files. regards, Devinder Rajput Stores Division Corporate Offices Chicago, IL (773) 442-6474 "Gaetano Mendola" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/08/2003 04:19 AM        

Re: [ADMIN] where is the database physically

2003-01-08 Thread Ing. Gabriel Monsalvo
Mitchell: The location of the postgresql database, is the value of the $PGDATA enviroment variable, if you are starting the postmaster manually the option -D specified the $PGDATA, if not look up for the script that runs postmaster at system start up. Postgres creates a directory for each databas

[ADMIN] Increase max_connections

2003-01-08 Thread Gaetano Mendola
Hi all, is it possible increase the max_connections value without restarting the server ? Ciao Gaetano ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[ADMIN] vaccumdb is giving "ERROR: out of free buffers: time to abort !"

2003-01-08 Thread Raja Kumar Thatte
Hai friends, I am using postgres-7.2 System is in production state. It has roughly 250 tables with 100 indexes. roughly 20 tables will have 1,00,000 records each. Lot of updations are going on. Lot of deletions are also going on. So have to do vacuumdb. So Whenever i do vaccumdb verbose analyze xy