Re: Can't login/createdb

Alright, I've got that taken care of now. Thanks to everyone who
responded. Next dumb question - I need to be able to connect to postgres
from PHP - I know that I need to start it up with the '-i' option, but I
need to make sure it starts up with that option when the machine
reboots. I found the 010.pgsql.sh file and it says to edit
$PG_DATA/postgresql.conf - so I went to my data dir and uncommented the
line that said 'tcpip_socket = false' and changed it to true. When
trying to connect from PHP, I get an error stating:

Warning: Unable to connect to PostgreSQL server: pqReadData() -- backend
closed the channel unexpectedly. This probably means the backend
terminated abnormally before or while processing the request.

I'm sure that, once again, I'm missing something simple (Yes, I did stop
and restart the postmaster :) Thanks,

By the way, this is FreeBSD 4.3 with PHP 4.0.6

Joe

wsheldah(at)lexmark(dot)com wrote:
>
> Use `su -` to be come root, then `su - postgres` to become the postgres
> superuser. Then you can connect to the database via psql and add other users,
> and give yourself database superuser permissions if you want. Assuming you're on
> a unix-like system of course.
>
> It's always good to mention your OS including version, and the version of
> Postgres you're using. But this should get you going. Have fun!
>
> Wes Sheldahl
>
> Joe Koenig <joe%jwebmedia(dot)com(at)interlock(dot)lexmark(dot)com> on 12/05/2001 03:30:06 PM
>
> Please respond to joe%jwebmedia(dot)com(at)interlock(dot)lexmark(dot)com
>
> To: pgsql-general%postgresql(dot)org(at)interlock(dot)lexmark(dot)com
> cc: (bcc: Wesley Sheldahl/Lex/Lexmark)
> Subject: [GENERAL] Can't login/createdb
>
> This is the stupidest thing ever and I'm sure I'm missing something
> simple, but here goes:
>
> I installed postgres and started it up as the post-installation-notes
> file says to do. It starts up just fine, but I cannot log into the
> interactive monitor, nor can I create any databases, even as root. I
> checked the pg_hba.conf file and it is set to let all local users log
> in. Whenver I type:
>
> psql
>
> to try and log in, I get FATAL 1: Database "username" does not exist in
> the system catalog. I've used pgsql before, but never installed it, so I
> assume I missed something stupid, but looking back through the docs I'm
> still missing it. Can anyone help me? Thanks,
>
> Joe
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org