Re: [ADMIN] Error: Could not change user id

2006-05-28 Thread Russell Davie
On Mon, 29 May 2006 14:57:15 +1000 Tim Allen <[EMAIL PROTECTED]> wrote: > Russell Davie wrote: > > On Sun, 28 May 2006 20:59:33 -0400 Tom Lane <[EMAIL PROTECTED]> > > wrote: > >> There is no such error message anywhere in the PG 7.4 source code. > >> I suppose it's coming out of whatever init scr

Re: [ADMIN] Error: Could not change user id

2006-05-28 Thread Tim Allen
Russell Davie wrote: On Sun, 28 May 2006 20:59:33 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: There is no such error message anywhere in the PG 7.4 source code. I suppose it's coming out of whatever init script you're using; have you tried reading the init script for enlightenment? Interesting

Re: [ADMIN] Error: Could not change user id

2006-05-28 Thread Russell Davie
On Sun, 28 May 2006 20:59:33 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > Russell Davie <[EMAIL PROTECTED]> writes: > > Manually starting postgresql by the user postgres: > > [EMAIL PROTECTED]:/etc/init.d$ ./postgresql-7.4 start > > chmod: changing permissions of `/var/run/postgresql': Operation no

Re: [ADMIN] Error: Could not change user id

2006-05-28 Thread Tom Lane
Russell Davie <[EMAIL PROTECTED]> writes: > Manually starting postgresql by the user postgres: > [EMAIL PROTECTED]:/etc/init.d$ ./postgresql-7.4 start > chmod: changing permissions of `/var/run/postgresql': Operation not permitted > * Starting PostgreSQL 7.4 database server:main > Error: Could not

[ADMIN] Error: Could not change user id

2006-05-28 Thread Russell Davie
Hi All I have used PostgreSQL for SQL-Ledger in Linux (Ubuntu) for about 6months and have run into PostgreSQL problems when it starts up. PostgreSQL is reporting errors about changing user id so that it falls over when the system boots. I've read this: http://archives.postgresql.org/pgsql-admin

Re: [ADMIN] PostgreSQL with SSL

2006-05-28 Thread Tom Lane
"=?ISO-8859-1?Q?Elvis_Henr=EDquez?=" <[EMAIL PROTECTED]> writes: > I'm trying to upgrade my PostgreSQL 8.1.0 instalation in Red Hat Linux 9 ( > PostgreSQL 8.1.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) > 3.2.220030222 (Red Hat Linux > 3.2.2-5) ) to version 8.1.4 cause of security patch jus

[ADMIN] PostgreSQL with SSL

2006-05-28 Thread Elvis Henríquez
Greetings list. I'm trying to upgrade my PostgreSQL 8.1.0 instalation in Red Hat Linux 9 (  PostgreSQL 8.1.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5)   ) to version 8.1.4 cause of security patch just released. Now I want to increase security in my con

Re: [ADMIN] \i running on windows

2006-05-28 Thread Cornelia Boenigk
Hi Jerome Change the Windows-backslashes into *normal* slashes like: test=# \i c:/Apache/htdocs/projekte/ulm_lokal/pg_dump.sql regards Conni ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choo