Hmm.
The only non-comment lines in my pg_hba.conf are as follows:
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
local all all password
# IPv4-style local connections:
host all all 127.0.0.1 255.255.255.255 password
# IPv6-style local connections:
host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff password
host all all 192.168.0.5 255.255.255.0 password
My postgresql.conf is stock from the installer at http://www.entropy.ch/software/macosx/postgresql/, except for uncommenting the tcpip_socket option and setting it to true.
And this is working fine.
When modifying these files, did you check to ensure that you did not modify permissions on the files/folders up to that point without switching them back? Wrong permissions on the data directory and its contents will cause postgres to abort startup.
You should be able to get results similar to these (watch the mode bits for the data dir and its contents; note that your results may vary slightly in other ways, and probably will):
Frank-Engels-Computer:/usr/local/pgsql root# ls -l
total 120
-rw------- 1 postgres wheel 155 15 Nov 11:44 .bash_history
-rw------- 1 postgres wheel 135 15 Nov 11:42 .psql_history
drwx------ 12 postgres wheel 408 13 Dec 08:16 data <--
drwxr-xr-x 3 postgres wheel 102 15 Nov 11:31 doc
drwxr-xr-x 22 postgres wheel 748 15 Nov 11:31 include
drwxr-xr-x 51 postgres wheel 1734 15 Nov 11:31 lib
-rw------- 1 postgres wheel 47761 13 Dec 08:16 logfile
-rw------- 1 postgres wheel 1338 26 Nov 22:28 postgres.log
drwxr-xr-x 13 postgres wheel 442 15 Nov 11:31 share
Frank-Engels-Computer:/usr/local/pgsql root# cd data/
Frank-Engels-Computer:/usr/local/pgsql/data root# ls -l
total 56
-rw------- 1 postgres wheel 4 15 Nov 11:38 PG_VERSION
drwx------ 6 postgres wheel 204 15 Nov 11:44 base
drwx------ 22 postgres wheel 748 13 Dec 08:16 global
drwx------ 3 postgres wheel 102 15 Nov 11:38 pg_clog
-rw------- 1 postgres wheel 3376 15 Nov 11:43 pg_hba.conf <--
-rw------- 1 postgres wheel 1441 15 Nov 11:38 pg_ident.conf
drwx------ 5 postgres wheel 170 6 Dec 17:42 pg_xlog
-rw------- 1 postgres wheel 7777 15 Nov 11:43 postgresql.conf <--
-rw------- 1 postgres wheel 60 13 Dec 08:16 postmaster.opts
-rw------- 1 postgres wheel 46 13 Dec 08:16 postmaster.pid
Frank-Engels-Computer:/usr/local/pgsql/data root#
On Dec 13, 2004, at 2:03 PM, Sivakatirswami wrote:
I can start the dbase in the foreground..
katir:~ postgres$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
LOG: database system was shut down at 2004-12-13 08:56:00 HST
LOG: checkpoint record is at 0/9E0780
LOG: redo record is at 0/9E0780; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 551; next OID: 17153
LOG: database system is ready
I see three postgres processes now in the activity monitor... but I can't find a way to issue commands to it from the cmd line.. there is no prompt after the last line above.
but
katir:~ postgres$ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile restart
doesn't work.. see below.
On Dec 13, 2004, at 8:45 AM, Sivakatirswami wrote:
Frank, thanks for your patient responses
Still no go..
katir:~ postgres$ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile restart
nothing happens, activity monitor doesn't show any start postgres processes started.
So, I'm stumped at this moment.
Is there some other log that will tell give us any useful feed back on what is happening.
Pierre: Yes, I suppose I could do a complete re-install, but, since two days ago I *was* able to start the server and all that I did in the interim was to "touch" the pg_hba.conf and postgresql.conf files, I *really* would like to fix this "manually" so that I get a grip on the issues and not simply "quit" and start over again. though, if there is no definitive diagnostic then I may have not choice...
In the meantime I'm logging into our new server in Connecticutt where Postgres is running just fine and going through the tutorials via ssh... creating test data bases and doing my "homework." (I'll have more to ask you about the rev ap server you installed after I get a little deeper into it...)
So, not having it running on my own machine is not a show stopper, just a nuisance.. normally I would be doing this kind of R & D during hours when I am off line... now I have to do it during on-line hours= "eats my day job time." i.e. the time when I should be working on web design, content and team coordination etc.
Pierre, perhaps you could email me off list your own pg_hba.conf and postgresql.conf files that you are using on your OSX machine, I would install those and see if it works
Thanks! Sivakatirswami Himalayan Academy Publications at Kauai's Hindu Monastery [EMAIL PROTECTED]
www.HimalayanAcademy.com, www.HinduismToday.com www.Gurudeva.org www.Hindu.org
On Dec 13, 2004, at 7:18 AM, Frank D. Engel, Jr. wrote:
This is trying to connect to PostgreSQL through a UNIX domain socket rather than TCP/IP. This should still be working, but if not, try a command like this:
psql -h <hostname> -U <username> dbname
So, no I cannot even start up the server at all.
Did you check the activity monitor again to see if it was running or not? The above given error message is a connectivity problem, any does not necessarily mean that the server is not running.
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
----------------------------------------------------------- Frank D. Engel, Jr. <[EMAIL PROTECTED]>
$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting life.
$
___________________________________________________________ $0 Web Hosting with up to 120MB web space, 1000 MB Transfer 10 Personalized POP and Web E-mail Accounts, and much more. Signup at www.doteasy.com
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
