Re: [ADMIN] PostgreSQL questions

1998-05-17 Thread Bruce Momjian
> >>try: > >>template1=> \h copy > Command: copy > Description: copy data to and from a table > Syntax: > copy [binary] [with oids] > {to|from} {|stdin|stdout} [using delimiters ]; > >>you can use "\t" a HTab or "," a comma. that is what i general

Re: [ADMIN] PostgreSQL questions

1998-05-17 Thread rjreilly
>1. Is there a TCL extension to this database? I see you have a pgtksh, pktclsh > interpreter compiled with the package. I was thinking if I can have the > postgresql interfaces incorporated to our TCL/TK interpreter. >>I belive the tcl/tk shell is a full shell with the PG libraries compile

Re: [ADMIN] postgresql-6.3.2 question

1998-05-17 Thread The Hermit Hacker
On Sun, 17 May 1998, Brett W. McCoy wrote: > On Sun, 17 May 1998, The Hermit Hacker wrote: > > > Why? Once you've added the postgres user, with his home > > directory, the postgres users himself should be able to do the complete > > install... > > Except for setting up the libraries and le

Re: [ADMIN] postgresql-6.3.2 question

1998-05-17 Thread Brett W. McCoy
On Sun, 17 May 1998, Peter Mount wrote: > > However, you DO want the postmaster to be started by user postgres > > within the startup scripts. > > Postgres will not run as root - it kills itself on purpose if you try. I think that's very wise! Brett W. McCoy

Re: [ADMIN] postgresql-6.3.2 question

1998-05-17 Thread Peter Mount
On Sun, 17 May 1998, Brett W. McCoy wrote: > On Sun, 17 May 1998, Peter Mount wrote: > > > I've installed it both ways: > > > > * As root, when installing under /usr/local > > * As postgres, when installing under /home/postgres > > > > The only thing I have yet to find how to setup without r

Re: [ADMIN] postgresql-6.3.2 question

1998-05-17 Thread Brett W. McCoy
On Sun, 17 May 1998, Peter Mount wrote: > I've installed it both ways: > > * As root, when installing under /usr/local > * As postgres, when installing under /home/postgres > > The only thing I have yet to find how to setup without root, is starting > the postmaster when the system boots. Fo

Re: [ADMIN] postgresql-6.3.2 question

1998-05-17 Thread Peter Mount
On Sun, 17 May 1998, The Hermit Hacker wrote: > On Sun, 17 May 1998, Brett W. McCoy wrote: > > > On Sun, 17 May 1998, Andy Lewis wrote: > > > > > I'm not totall sure but, I wouldn't think that user postgres has enough system > > > rights to install. > > > > You should be root when doing the ac

Re: [ADMIN] postgresql-6.3.2 question

1998-05-17 Thread Brett W. McCoy
On Sun, 17 May 1998, The Hermit Hacker wrote: > Why? Once you've added the postgres user, with his home > directory, the postgres users himself should be able to do the complete > install... Except for setting up the libraries and letting ldconfig know where they are. Actually, I had to

Re: [ADMIN] postgresql-6.3.2 question

1998-05-17 Thread The Hermit Hacker
On Sun, 17 May 1998, Brett W. McCoy wrote: > On Sun, 17 May 1998, Andy Lewis wrote: > > > I'm not totall sure but, I wouldn't think that user postgres has enough system > > rights to install. > > You should be root when doing the actual software installation to > /usr/local, but everything else

Re: [ADMIN] postgresql-6.3.2 question

1998-05-17 Thread Brett W. McCoy
On Sun, 17 May 1998, Andy Lewis wrote: > I'm not totall sure but, I wouldn't think that user postgres has enough system > rights to install. You should be root when doing the actual software installation to /usr/local, but everything else should be done as the postgres user. Brett W. McCoy

Re: [ADMIN] postgresql-6.3.2 question

1998-05-17 Thread The Hermit Hacker
On Sun, 17 May 1998, Andy Lewis wrote: > I'm not totall sure but, I wouldn't think that user postgres has enough system > rights to install. Everything for PostgreSQL gets installed, generally, in postgres users home directory...I've never had a requirement to install as anything but pos

Re: [ADMIN] postgresql-6.3.2 question

1998-05-17 Thread Andy Lewis
I'm not totall sure but, I wouldn't think that user postgres has enough system rights to install. Andy On Sat, 16 May 1998, The Hermit Hacker wrote: > >Hello, > >My question is this: > >Do I have to be user progres to install? Can I not use an existing user? If >yes, is there any change to the

[ADMIN] Re: your mail

1998-05-17 Thread Peter Mount
On Sat, 16 May 1998, The Hermit Hacker wrote: > I read several documentions you provided, and followed the directions. > The directions are the following: > > 1. change the account into 'postgres'. > 2. change the 'pg_hba.conf' file in the path /usr/local/pgsql/data. > hostall 0.0.

Re: [ADMIN] PostgreSQL questions

1998-05-17 Thread Peter Mount
On Sat, 16 May 1998, The Hermit Hacker wrote: > I just installed the postgresql database into our Sun enterprise 5000 machine. > I have a few questions to ask if you don't mind. > > 1. Is there a TCL extension to this database? I see you have a pgtksh, pktclsh >interpreter compiled with the