[ADMIN] Urgent: Restoring many schemas in a database

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello all, I am trying to restore a 7.3 database with many schemas and schema users in it. The issue I am having is that there are many \connect statements in the backup file and it keeps asking me for a new password each time. Is there an easier w

Re: [ADMIN] interpret vacuum verbose output

On Wed, 4 Jun 2003, Shankar K wrote: > hi all, > > I'm trying to evaluate the frequecy to run vacuum > analyze on key tables. so if anyone could help me to > interpret the output of vacuum analyze verbose output > that would be great. below is the output of one of our > major indexes. > > INFO

Re: [ADMIN] Urgent: Restoring many schemas in a database

Hi, have you considered the option of putting "trust" as auhentication in pg_hba.conf already. other option is to user .pgpass file but i am not sure of the exact details regds mallah. > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hello all, > > I am trying to restore a 7.3 databa

Re: [ADMIN] Urgent: Restoring many schemas in a database

On Thu, 2003-06-05 at 11:49, Stephen J. Thompson wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hello all, > > I am trying to restore a 7.3 database with many schemas and schema users in > it. The issue I am having is that there are many \connect statements in the > backup file an

Re: [ADMIN] Urgent: Restoring many schemas in a database

"Stephen J. Thompson" <[EMAIL PROTECTED]> writes: > I am trying to restore a 7.3 database with many schemas and schema users in > it. The issue I am having is that there are many \connect statements in the > backup file and it keeps asking me for a new password each time. Is there an > easier wa

Re: [ADMIN] Urgent: Restoring many schemas in a database

On Thu, Jun 05, 2003 at 11:49:25 +0100, "Stephen J. Thompson" <[EMAIL PROTECTED]> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hello all, > > I am trying to restore a 7.3 database with many schemas and schema users in > it. The issue I am having is that there are many \connect

[ADMIN] Fw: Starting postmaster as a service (newbie)

  Hi,    I have got a peculiar problem with my postmaster.I have installed cyg-ipc and postmaster as services on Windows 2000. But when I restart the system , the postmaster doesn't start.I figured that it is because I have to do the init db everytime this happens. But I have to empty the d

[ADMIN] Starting postmaster as a service (newbie)

Hi,    I have got a peculiar problem with my postmaster.I have installed cyg-ipc and postmaster as services on Windows 2000. But when I restart the system , the postmaster doesn't start.I figured that it is because I have to do the init db everytime this happens. But I have to empty the data

Re: [ADMIN] interpret vacuum verbose output

Shankar K <[EMAIL PROTECTED]> writes: > I'm trying to evaluate the frequecy to run vacuum > analyze on key tables. so if anyone could help me to > interpret the output of vacuum analyze verbose output > that would be great. > INFO: Removed 55448 tuples in 2367 pages. > CPU 0.04s/0.11u sec

Re: [ADMIN] Backup and Restore

This is a well known issue, you can change Postgress version to 7.3.3 and the pg_dump on that version is more smart. Gaetano - Original Message - From: "David A. Leedom" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 05, 2003 1:56 PM Subject: [ADMIN] Backup and Restore

[ADMIN] number of opened files

Hello, We use PG 7.3.2 and we noticed that at 12 PM and 12 AM (when we do a vaccumdb -v -a -z) , number of open files suddenly decrease (for example from 7300 open files to 4500). Is it normal that when we do a vacuumdb, the number of open files decrease ? Thank you ! Jean-Arthur Silve EuroVo

[ADMIN] Shared_buffers and kernel parameters, tuning

Title: Shared_buffers and kernel parameters, tuning After days of searching and testing I have come up with this way of configuring our postgresql 7.2 db. I have not yet increased my shared_buffer as high as suggested below on our prod machine (24-7 high traffic), but after testing on our dev

[ADMIN] No acceptable C compiler found

When I issue the command ./configure when installing POSTGRESQL I encounter the error "configure: error: No acceptable C compiler found in PATH " Can someone advice me on what to do with this error. Thank you! __ Do you Yahoo!? Yahoo! Calendar - Free online calen

[ADMIN] Doubt about Database Migration Wizard

Gents, Whent I try to use Database Migration Wizard through pgAdminII and I select the MS Jet Ole DB in order to import a MS Access Database to PostgreSQL, there is a field named Provider String that I don't know what it means. Can you tell me what is this? Thank you. Rgds, Marco Aurélio

Re: [ADMIN] Shared_buffers and kernel parameters, tuning

"Lending, Rune" <[EMAIL PROTECTED]> writes: > in postgresql.conf: > shared_buffers = 117248 (shmmax / 2 / 1024 / 8 ) This I got from this forum. This is a factor of 10, maybe a factor of 100, more than you need. It's usually better to let the kernel manage memory. See the pgsql-performance archiv

Re: [ADMIN] No acceptable C compiler found

um... we're going to need a little more info to help, like your OS for starters. Also do you know if you have a copy of gcc or any other compiler on the system? If so what version? Robert Treat On Thu, 2003-06-05 at 04:41, Marvin wrote: > When I issue the command ./configure when installing > PO