Re: [GENERAL] PostgreSQL fails to start

2010-02-20 Thread Reid Thompson
On 2/20/2010 4:42 PM, John Gage wrote: I have had the same/similar problem on a Mac. Postgres creates a user "postgres" and the only way that user can see files is for them to exist outside of any other particular user's home directory. I placed the files in the root directory!? I would like, I

Re: [GENERAL] PostgreSQL fails to start

2010-02-20 Thread Reid Thompson
On 2/20/2010 4:42 PM, John Gage wrote: I have had the same/similar problem on a Mac. Postgres creates a user "postgres" and the only way that user can see files is for them to exist outside of any other particular user's home directory. I placed the files in the root directory!? I would like, I

Re: [GENERAL] PostgreSQL fails to start

2010-02-20 Thread John Gage
I have had the same/similar problem on a Mac. Postgres creates a user "postgres" and the only way that user can see files is for them to exist outside of any other particular user's home directory. I placed the files in the root directory!? I would like, I think, to give "postgres" privi

Re: [GENERAL] PostgreSQL fails to start

2010-02-20 Thread Massa, Harald Armin
Eddie, > It also seems to show a weakness in PostgreSQL's logging, in that (a) it > would help a lot if it just printed its error to stderr, and (b) the log > message it did send to the event log was of the form "directory not found" > rather than "permission denied". > problem for sending to st

Re: [GENERAL] PostgreSQL fails to start

2010-02-20 Thread Heddon's Gate Hotel
Thanks very much for the tip, Ray - it has led me to discover the Windows Event Viewer, which I did not even know existed. It was a sort of help, because it enabled me - eventually - to diagnose that the problem was to do with directory permissions. I had installed PostgreSQL with its data di

Re: [GENERAL] PostgreSQL fails to start

2010-02-19 Thread Raymond O'Donnell
On 19/02/2010 13:10, Heddon's Gate Hotel wrote: > I've installed postgreSQL 8.4 on a Windows XP machine, and I can't get > it to start. Choosing Start Server from the menu produces a DOS box > that remains blank for about 3 minutes, then comes up with this error > message: > > The postgresql-8.4

[GENERAL] PostgreSQL fails to start

2010-02-19 Thread Heddon's Gate Hotel
I've installed postgreSQL 8.4 on a Windows XP machine, and I can't get it to start. Choosing Start Server from the menu produces a DOS box that remains blank for about 3 minutes, then comes up with this error message: The postgresql-8.4 service is starting. The

Re: [GENERAL] postgresql fails to start after symlinking pgdata dir

2007-02-05 Thread Gene
Tom, You were right i just considered that a few minutes ago before getting your response. I set SELINUX=disabled in /etc/sysconfig/selinux and it started up ok. a note in this file: http://pgfoundry.org/docman/?group_id=148 would be handy for those who forget easily and aren't sysadmins :)

Re: [GENERAL] postgresql fails to start after symlinking pgdata dir

2007-02-05 Thread Tom Lane
Gene <[EMAIL PROTECTED]> writes: > In the past I've always done the following with success (this is under > fedora core 6 x86_64): > mv /var/lib/pgsql/data /data/pg/ > ln -s /data/pg/data /var/lib/pgsql/data > /etc/init.d/postgresql start > I just installed 8.2.2 on a new FC6 machine and when I d

[GENERAL] postgresql fails to start after symlinking pgdata dir

2007-02-05 Thread Gene
In the past I've always done the following with success (this is under fedora core 6 x86_64): mv /var/lib/pgsql/data /data/pg/ ln -s /data/pg/data /var/lib/pgsql/data /etc/init.d/postgresql start I just installed 8.2.2 on a new FC6 machine and when I do that it fails to start. The logs reveal no

Re: [GENERAL] Postgresql fails to start? (Update)

2005-06-09 Thread Tom Lane
Dianne Yumul <[EMAIL PROTECTED]> writes: > # chcon -u system_u -r object_r -t postgresql_log_t > /home/postgres/pgstartup.log > chcon: can't apply partial context to unlabeled file > /home/postgres/pgstartup.log > [but this works:] > # chcon system_u:object_r:postgresql_log_t /home/postgres/pgsta

Re: [GENERAL] Postgresql fails to start? (Update)

2005-06-09 Thread Dianne Yumul
Just an update . . . I tried upgrading kernel to 2.6.11.11 (kernel.org) but was unsuccessful (due to i2c and gcc 4.0 issue). So I settled for the one on the fedora development repository. But that didn't help, upgraded other stuff too like selinux-policy-targeted and initscripts. Beginning to pull

Re: [GENERAL] Postgresql fails to start?

2005-06-07 Thread Tom Lane
Dianne Yumul <[EMAIL PROTECTED]> writes: > I still get the /usr/bin/chcon message but only when I run the command > by hand, even after upgrading coreutils: > # /usr/bin/chcon -u system_u -r object_r -t postgresql_log_t "$PGLOG" > /usr/bin/chcon: can't apply partial context to unlabeled file We

Re: [GENERAL] Postgresql fails to start?

2005-06-07 Thread Dianne Yumul
I've seen reports of that before, eg, https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=152931 but it's far from clear why some people see this and some don't. I feel such a goof ball. I searched bugzilla for an hour yesterday but for some reason I did not find that bug. But that solved my p

Re: [GENERAL] Postgresql fails to start?

2005-06-07 Thread Tom Lane
Dianne Yumul <[EMAIL PROTECTED]> writes: > # rm -f pgstartup.log > # /etc/rc.d/init.d/postgresql start > /usr/bin/chcon: can't apply partial context to unlabeled file > /home/postgres/pgstartup.log > Starting postgresql service: [FAILED] > # ps aux | grep postmaster >

Re: [GENERAL] Postgresql fails to start?

2005-06-07 Thread Dianne Yumul
Can you say anything about the difference between the times where it gives the message and the times where it doesn't? I get the message when I remove pgstartup.log before starting postgresql. But if I leave pgstartup.log, it just says it failed to start. Please see output below: # /etc/rc.d

Re: [GENERAL] Postgresql fails to start?

2005-06-07 Thread Dianne Yumul
Um, exactly which Postgres RPMs do you have installed? Thanks for the response. I have the following installed: postgresql-server-8.0.3-1 postgresql-8.0.3-1 postgresql-jdbc-8.0.3-1 postgresql-libs-8.0.3-1 postgresql-devel-8.0.3-1 I downloaded these from the fedora development repository. I use

Re: [GENERAL] Postgresql fails to start?

2005-06-06 Thread Tom Lane
Dianne Yumul <[EMAIL PROTECTED]> writes: > We have Fedora Core 4 Test 3 installed on a development box and just > recently installed Postgresql 8.0.3. Sometimes, when starting > postgresql with the /etc/rc.d/init.d/postgresql script, it gives me the > following: > /usr/bin/chcon: can't apply pa

[GENERAL] Postgresql fails to start?

2005-06-06 Thread Dianne Yumul
Hello list, We have Fedora Core 4 Test 3 installed on a development box and just recently installed Postgresql 8.0.3. Sometimes, when starting postgresql with the /etc/rc.d/init.d/postgresql script, it gives me the following: /usr/bin/chcon: can't apply partial context to unlabeled file /ho