hello,

With the account "mylogin" I do : initdb -D /home/mylogin/basedir
all is ok

but when i do : psql template1 , respond that user mylogin not exist ?
if i do creatuser mylogin respond not permitted !

I dont understant why this is not ok

can you hekp me (is the login that run initdb begin superuser ? do
create user ?)

thanks

Vincent

On Sun, 15 Aug 2010 21:57:08 +0200, Didier wrote:

The problem is that a Postgres instance is created with the user
"postgres" and a database "postgres". Those values are probably hard
coded into the code itself and cannot be changed easily. Do you have any
reason for not following the standards?



--
http://mgogala.byethost5.com

Mladen Gogala wrote on 16.08.2010 04:50:
The superuser account can both be specified when running initdb, it is not hardcoded doesn't need to be "postgres" (it defaults to the account running initdb)

There is no built-in default database other than template0 and template1.
Having a database called "postgres" is only by convention.

Thomas

Didier wrote on 15.08.2010 21:57:
What exactly is the error message?
How is the server started? Does it actually use the data directory in /home/mylogin/basedir
Do you have any PGXXX variable defined?
(See: http://www.postgresql.org/docs/curre...pq-envars.html)
Is it possible you have two instances running on different ports?

Regards
Thomas

Le 16/08/2010 08:34, Thomas Kellerer a écrit :
message : is it normal ?

pg_ctl -D /home/plagnes/basedir -l logfile start
postmaster successfully started
ps -ef | grep post

mylogin 26095 1 0 Aug15 ? 00:00:00
/usr/lib/postgresql/7.4/bin/postmaster -D /home/mylogin/basedir
mylogin 26096 26095 0 Aug15 ? 00:00:00 postgres: stats buffer
process
mylogin 26097 26096 0 Aug15 ? 00:00:00 postgres: stats
collector process
mylogin 31356 31321 0 10:21 pts/1 00:00:00 grep post


and

psql
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket
"/var/run/postgresql/.s.PGSQL.5432"?

? what to do ? what can be not ok ?

thanks

Vincent (sorry my english is not very good)

Le 16/08/2010 04:50, Mladen Gogala a écrit :
what is the standards ?
I install postgresql as root
so I initdb with user "mylogin"
and I launch with user "mylogin"

I do this in other server ans all is ok, I dont know why is not ok on debian

Didier wrote on 16.08.2010 10:25:
Oh - you are running an unsupported version (7.4)

I have no experience with using socket connections, but could it be a permission problem on "/var/run/postgresql/"?
Can the "mysql" user (under which the postmaster is running) write to that directory?

As an alternative you could enable tcpip connection and see if that helps.

But first of all you should use a supported PostgreSQL version...

Thomas

Le 16/08/2010 11:08, Thomas Kellerer a écrit :