Re: [ADMIN] Starting postgres server on mac os x 10.6.8

2012-02-05 Thread Scott Ribe
On Feb 5, 2012, at 3:58 PM, Andrew Barinov wrote: > I got it from here: http://www.postgresql.org/download/macosx/ Ah, those are all external to the postgres web site. > I found the log file (the location is set inside of pgAdmin), it turns > out my pg_hba.conf file had improper permissions set

Re: [ADMIN] Starting postgres server on mac os x 10.6.8

2012-02-05 Thread Andrew Barinov
I got it from here: http://www.postgresql.org/download/macosx/ I found the log file (the location is set inside of pgAdmin), it turns out my pg_hba.conf file had improper permissions set (postgres was being denied access). Thanks for pointing me to the right direction! On Sun, Feb 5, 2012 at 2:3

Re: [ADMIN] Starting postgres server on mac os x 10.6.8

2012-02-05 Thread Scott Ribe
On Feb 5, 2012, at 3:31 PM, Andrew Barinov wrote: > Actually no, I installed it using a tarball of the postgres website. > Everything related to postgres is located inside /Libary/PostgreSQL/ > directory, so I'll start there first. Do you know the exact location the > logfile is put in from the

Re: [ADMIN] Starting postgres server on mac os x 10.6.8

2012-02-05 Thread Andrew Barinov
Actually no, I installed it using a tarball of the postgres website. Everything related to postgres is located inside /Libary/PostgreSQL/ directory, so I'll start there first. Do you know the exact location the logfile is put in from the tarball installation? On Sun, Feb 5, 2012 at 2:28 PM, Scott

Re: [ADMIN] Starting postgres server on mac os x 10.6.8

2012-02-05 Thread Scott Ribe
On Feb 5, 2012, at 3:14 PM, Andrew Barinov wrote: > This is my first time trying to solve a postgres issue, I just now realized > that the command I tried before wasn't to open the logfile but to do > something else. I couldn't find the command in the postgres docs to open and > see the content

Re: [ADMIN] Starting postgres server on mac os x 10.6.8

2012-02-05 Thread Andrew Barinov
Hi Scott, This is my first time trying to solve a postgres issue, I just now realized that the command I tried before wasn't to open the logfile but to do something else. I couldn't find the command in the postgres docs to open and see the contents of the logfile, can you tell me what it is? On S

Re: [ADMIN] Starting postgres server on mac os x 10.6.8

2012-02-05 Thread Scott Ribe
On Feb 4, 2012, at 11:16 PM, Andrew Barinov wrote: > Shouldn't the postgres superuser be allowed to see the logfile? What do you mean "see the logfile"??? You're telling it to write into a file named logfile, in the current directory. Obviously, the user that postgres is being run under does no

Re: [ADMIN] Starting postgres server on mac os x 10.6.8

2012-02-04 Thread Andrew Barinov
I tried the following command: bash-3.2$ /Library/PostgreSQL/9.1/bin/pg_ctl -D /Library/PostgreSQL/9.1/data start -l logfile server starting sh: logfile: Permission denied Shouldn't the postgres superuser be allowed to see the logfile? On Sat, Feb 4, 2012 at 9:21 PM, Scott Ribe wrote: > Find th

Re: [ADMIN] Starting postgres server on mac os x 10.6.8

2012-02-04 Thread Scott Ribe
Find the log file and see what it says. On Feb 4, 2012, at 9:50 PM, Andrew Barinov wrote: > Why is the postgres not starting? -- Scott Ribe scott_r...@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To m

[ADMIN] Starting postgres server on mac os x 10.6.8

2012-02-04 Thread Andrew Barinov
Hello, I'm having trouble restarting the postgres server on my mac. The error I am getting when I try to run PG is: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? Here's the command that I