[ADMIN] replication recommendations

2003-01-14 Thread Matt Doughty
I would like to setup database replication. It will primarily be used to maintain a quick swappable spare. I would also like to be able to shutdown backup occationally to make file system level backups while maintaining the ability to bring the spare up to date with the primary database once it c

Re: [ADMIN] Deadlock Checker doesn't see foreign-key locks

2003-01-14 Thread Andrew Biagioni
Stephan Szabo wrote: On Mon, 13 Jan 2003, Andrew Biagioni wrote: It appears to me that the Deadlock Checker doesn't see (and thus release) foreign-key-based locks (see below for details). Am I missing something? Is there a configuration item I am unaware of? We're goi

Re: [ADMIN] Case Studio Postgresql

2003-01-14 Thread Vida Luz Arista
Yes, I am searching companies or goverments who are currently using PostgreSQL Regards, On Tue, 14 Jan 2003, Jyry Kuukkanen wrote: > > Hello Vida Luz Arista > > I am not quite sure what do you mean by your message. > > Do you want links or such of companies or goverments who are currently

Re: [ADMIN] Case Studio Postgresql

2003-01-14 Thread Tim Ellis
On Tue, 2003-01-14 at 13:20, Vida Luz Arista wrote: > I am analyzing to Postgresql for e-goverment, nevertheless I need to know > in that companies, country and so that aims this being used this data > base. > > Where I can Find this information? Hola, There are case studies on the PostgreSQL w

Re: [ADMIN] Case Studio Postgresql

2003-01-14 Thread David F. Skoll
On Tue, 14 Jan 2003, Vida Luz Arista wrote: > I am analyzing to Postgresql for e-goverment, nevertheless I need to know > in that companies, country and so that aims this being used this data > base. My anti-spam solution at http://www.canit.ca/ is built around PostgreSQL. The largest installati

Re: [ADMIN] Case Studio Postgresql

2003-01-14 Thread Jyry Kuukkanen
Hello Vida Luz Arista I am not quite sure what do you mean by your message. Do you want links or such of companies or goverments who are currently using PostgreSQL? Cheers, --jq On Tue, 14 Jan 2003, Vida Luz Arista wrote: > Hi, > > I am analyzing to Postgresql for e-goverment, nevertheless

[ADMIN] Case Studio Postgresql

2003-01-14 Thread Vida Luz Arista
Hi, I am analyzing to Postgresql for e-goverment, nevertheless I need to know in that companies, country and so that aims this being used this data base. Where I can Find this information? Thanks in Advanced, Regards. ---(end of broadcast)--- T

Re: [ADMIN] Newbie question

2003-01-14 Thread Robert Treat
On Tue, 2003-01-14 at 09:12, David wrote: > How to grant a whole database for a certain user ? > i mean: > > grant usage on mydb.* to myuser identified by 'mypasswd' > > Is available something similar with postgres or should i write a shell > script, for example? > Thank you very much!!! You'll

[ADMIN] Newbie question

2003-01-14 Thread David
Title: Newbie question How to grant a whole database for a certain user ? i mean: grant usage on mydb.* to myuser identified by 'mypasswd' Is available something similar with postgres or should i write a shell script, for example? Thank you very much!!!

Re: [ADMIN] query problem

2003-01-14 Thread Nick Fankhauser
Helen- What I meant by "code sample" was the java code. Clearly there is nothing wrong with the sql, but since you're probably returning more columns with the first statement than the second one, my guess is that the java code which processes the ResultSet works in the first case because it is exp

[ADMIN] is it safe to change pg_type ?

2003-01-14 Thread Rajesh Kumar Mallah.
Hi , in the lack of ALTER DOMAIN command , if i have to increase from varchar(100) to varchar(250) for a given domain can i safetly update typtypmod in pg_type ? regds mallah. -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (22

Re: [ADMIN] pg_dump and Users

2003-01-14 Thread Gareth Kirwan
How does pg_dumpall sound ? -Original Message- Hey everyone, Just a quicky... I need to dump a database completely while a system is re-installed.. and then reload it afterwards. I'm planning on using pg_dump -C database > Flatfile pgsql -d database -f Flatfi

[ADMIN] pg_dump and Users

2003-01-14 Thread Gareth Kirwan
Title: Gareth Stationery Hey everyone,       Just a quicky...     I need to dump a database completely while a system is re-installed.. and then reload it afterwards.     I'm planning on using     pg_dump -C database > Flatfile     pgsql -d database -f Flatfile     But this doesn'