Thread: psql -p 5433; create database test; \c test failing

Hi,

this is from HEAD of a few days ago, it looks suspicious to me.
8.2devel runs on port 5433.

markus@katerina2:~/pgsql$ bin/psql -p 5433 template1 markus
Welcome to psql 8.2devel, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

template1=# create database test;
CREATE DATABASE
template1=# \c test
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"?
Previous connection kept

Why is it trying to use 5432? Am I missing something?

On Sat, Mar 11, 2006 at 03:13:49PM +0600, Markus Bertheau wrote:
> template1=# \c test
> 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"?
> Previous connection kept
>
> Why is it trying to use 5432? Am I missing something?

Do you have the PGPORT environment variable set to 5432?

--
Michael Fuhr

2006/3/11, Michael Fuhr <mike@fuhr.org>:

> Do you have the PGPORT environment variable set to 5432?

No.

Markus

On Sat, Mar 11, 2006 at 02:41:50AM -0700, Michael Fuhr wrote:
> On Sat, Mar 11, 2006 at 03:13:49PM +0600, Markus Bertheau wrote:
> > Why is it trying to use 5432? Am I missing something?
>
> Do you have the PGPORT environment variable set to 5432?

This commit looks like it might be relevant:

http://archives.postgresql.org/pgsql-committers/2006-02/msg00139.php

Discussions of development code should probably be on -hackers.

--
Michael Fuhr

unsubscribe