Re: [ADMIN] adduser postgres

2004-09-20 Thread Robert Treat
On Tuesday 14 September 2004 11:38, Yiqun Lin wrote: > Hello, > > I have a Fedora core 2 box and just installed postgresSQL 7.3.7. I added a > user postgres using the instruction from an installation menu: adduser > postgres. Then I tried to su - postgres, but it prompted me "incorrect > password".

Re: [ADMIN] windows docs?

2004-09-20 Thread Robert Treat
On Thursday 16 September 2004 15:13, Bender, Cheryl wrote: > When starting the Windows psql client I get a warning that the "console > codepage (437) differs from the windows codepage (1252)" and to see > installation on Windows for details. I am having trouble finding this > documentation. I've

Re: [ADMIN] The link for the Beta 2 Windows version of 8.0 is not working

2004-09-20 Thread Robert Treat
On Saturday 18 September 2004 19:19, Federico Alves wrote: > The link for the Beta 2 Windows version of 8.0 is not working. How do I > download it? > obligatory obvious questions: which link? define not working... try looking at http://pgfoundry.org/projects/pginstaller/ it should have the lat

Re: [ADMIN] Postgres setup question

2004-09-20 Thread Robert Treat
On Monday 20 September 2004 12:04, [EMAIL PROTECTED] wrote: > Hi there, > > I've been looking into configuring Postgres for a small/medium sized group > of users for a local computer science society. We want to give each user > their own database, and have it administratable via the Usermin web >

Re: [ADMIN] unique constraints on foreign keys

2004-09-20 Thread Stephan Szabo
On Mon, 20 Sep 2004, Jaime Casanova wrote: > --- Stephan Szabo <[EMAIL PROTECTED]> > escribió: > > > > On Mon, 20 Sep 2004, Jaime Casanova wrote: > > > > > There is a way to not enforce the creation of a > > > primary or unique index on a referenced table? > > > > Not really. It's not the index t

Re: [ADMIN] unique constraints on foreign keys

2004-09-20 Thread Jaime Casanova
--- Stephan Szabo <[EMAIL PROTECTED]> escribió: > > On Mon, 20 Sep 2004, Jaime Casanova wrote: > > > There is a way to not enforce the creation of a > > primary or unique index on a referenced table? > > Not really. It's not the index that's important > per-se, it's the uniqueness that is impl

[ADMIN] unsubscribe

2004-09-20 Thread Ramiro Batista da Luz
Mensagem Enviada utilizando o Onda Mail. http://www.onda.com.br Onda Provedor de Servicos S/A ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an approp

Re: [ADMIN] unique constraints on foreign keys

2004-09-20 Thread Stephan Szabo
On Mon, 20 Sep 2004, Jaime Casanova wrote: > I have a reference table that holds all the status > used in a system (it's a very little table just 10 or > 15 rows). > > create table status ( > cod_status char(2) not null primary key, > nam_status textnot null > ); > > create

[ADMIN] unique constraints on foreign keys

2004-09-20 Thread Jaime Casanova
Hi all, I have a reference table that holds all the status used in a system (it's a very little table just 10 or 15 rows). create table status ( cod_status char(2) not null primary key, nam_status textnot null ); create table some_other_table ( ... definition of the tabl

[ADMIN] Postgres setup question

2004-09-20 Thread rjyoung
Hi there, I've been looking into configuring Postgres for a small/medium sized group of users for a local computer science society. We want to give each user their own database, and have it administratable via the Usermin web interface (some people will be fairly green, and we felt Usermin gives

Re: [ADMIN] access rights

2004-09-20 Thread Bruno Wolff III
On Sun, Sep 19, 2004 at 02:01:10 -0300, [EMAIL PROTECTED] wrote: > I need a data base to install with my application, but i want that it can > be accessed only by the application. Because it runs on the customer computer > and i dont want he be able to watch into my database. It is posible. I mea

[ADMIN] The link for the Beta 2 Windows version of 8.0 is not working

2004-09-20 Thread Federico Alves
The link for the Beta 2 Windows version of 8.0 is not working. How do I download it?   Question: is this a real windows version? Not cygwin?     Federico

[ADMIN] access rights

2004-09-20 Thread ctnan
I need a data base to install with my application, but i want that it can be accessed only by the application. Because it runs on the customer computer and i dont want he be able to watch into my database. It is posible. I mean: if my postgres database is on his Windows 2000 and he has the Administ

Re: [ADMIN] pg_dumpall failed

2004-09-20 Thread Tom Lane
Chuming Chen <[EMAIL PROTECTED]> writes: > I am using pg_dumpall (pg_dumpall -o > backup) to backup postgresql > 7.2.3 datatbase on Redhat Linux 8. It worked well, but recently, it > failed and gave me the following messages: > pg_dump: query to get data of sequence "est_att_p_por_id_seq" retur

[ADMIN] pg_dumpall failed

2004-09-20 Thread Chuming Chen
Hi, all, I am using pg_dumpall (pg_dumpall -o > backup) to backup postgresql 7.2.3 datatbase on Redhat Linux 8. It worked well, but recently, it failed and gave me the following messages: pg_dump: query to get data of sequence "est_att_p_por_id_seq" returned name "est_att_p_porites_id_seq" pg_

Re: [ADMIN] connections manager

2004-09-20 Thread Oliver Elphick
On Thu, 2004-09-16 at 15:09, "Lic. Guillermo González" wrote: > Hi, > > I would like to know if there is a script or software that can bring me > information about the connections on my PostgreSQL databases. select * from pg_stat_activity; -- Oliver Elphick