[ADMIN] Re: Graphics GUI for PostgreSQL

2001-03-31 Thread PostgreSQL newbie
Or one can use webmin to manage. But I haven't figured out how. The problem is when I enter PostgreSQL server, it rejects me and says "Webmin needs to know your PostgreSQL administration login and password in order to manage your database." Does anyone know how to setup "PostgreSQL administrati

[ADMIN] About configuring PostgreSQL

2001-03-31 Thread vinod tp
Hello sir I installed PostgreSQL when i installed Linux7.0 and then i tried to load PostgreSQL by typing $postgresql start ,then it started after that I dont know how to use the PostgreSQL Will you please send how to configure the PostgreSQL and how to use this? And how to connect the Postgre

[ADMIN] Recommended VACUM timing...

2001-03-31 Thread August Zajonc
For large tables that require a 24/7 uptime and see around 6-10 million changes a day, how do I run VACUM without taking the database/table down. Considering moving from MySQL, but can't quite understand how to run PostgreSQL in a production enviroment properly. August ---

[ADMIN]

2001-03-31 Thread IGB.NET
subscribe ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[ADMIN] Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP

2001-03-31 Thread Tom Lane
Marcin Kowalski <[EMAIL PROTECTED]> writes: > DON'T DO THIS!!! > --- > CREATE UNIQUE INDEX shadow_index ON pg_shadow (usename) > --- Indeed, trying to create nonstandard indexes on system catalogs is a BAD idea. There probably ought to be a check to prevent you from trying. > What can I

Re: [ADMIN] Help - Index on pg_shadow corruption!! Database down!!

2001-03-31 Thread Andrea Fanfani
On Fri, Mar 30, 2001 at 01:33:39PM +0200, Marcin Kowalski wrote: > Hi Concerned CItizens [...] Maybe but *without* warranty you can install another copy of postgresql, take the pg_shadow file and substitute to the corrupted file. Make a total backup first, imho is a high risk change. Regards