Connecting to PostGreSQL on same machine: Mac OSX
Sivakatirswami
katir at hindu.org
Mon Dec 13 15:15:09 EST 2004
OK, see previous memo on this...
I *had* deleted the line with all the ffff:ffff:ffff:
but.. seeing this.. I reinserted it..think, so, my pg_hba.conf looks
just like yours
but:
katir:/Users/katir postgres$ /usr/local/pgsql/bin/pg_ctl -D
/usr/local/pgsql/data -l logfile restart
still fails, no error msg... just, nothing happens.
I guess i should take this to a postgres forum now... ? Thanks for you
patience and help so far... at least i can start up via the postmaster
(see previous memo)
Sivakatirswami
On Dec 13, 2004, at 9:20 AM, Frank D. Engel, Jr. wrote:
> 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:
>
>> More on this...
>>
>> 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
>>> katir at hindu.org
>>>
>>> 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
>>> use-revolution at lists.runrev.com
>>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>>
>>
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>
>>
> -----------------------------------------------------------
> Frank D. Engel, Jr. <fde101 at fjrhome.net>
>
> $ 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
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
More information about the use-livecode
mailing list