From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Alessandro (at) GMail" <neurotrotter(at)gmail(dot)com>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: weird problem with pgadmin & postgres on debian |
Date: | 2006-03-20 09:09:36 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E4011C95AF@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
________________________________
From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Alessandro @
GMail
Sent: 18 March 2006 17:26
To: pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] weird problem with pgadmin &
postgres on debian
mmm i think you're right and it's not the same installation as i
have not defined the PGDATA environment variable yet, so i don't know
what he started at boot time...(i run the db with the -D option right
now)
another thing i forgot to say is that the first time i put the
data folder in my user home(/home/alex/.postgres/data) instead of
/usr/local/pgsql/data/ ...but user postgres should be a SU so it
shouldn't make any difference, or am i wrong?
then i changed the folder to /usr/local/pgsql/data/ but pgadmin
refused still to connect. Only after i slaughtered
/etc/init.d/postgresql-8.1 i was able to connect with pgadmin...
Sounds like you are in a proper mess of defaults, command line options
and envvars!! I'd hunt down all clusters (maybe, find / -name
postgresql.conf), figure out which one you want to start, and then make
sure that you either start it with the -D option, or by explicitly
setting $PGDATA first. Don't rely on su to preserve the environment or
anything like that as you're bound to run into trouble as soon as you
type 'su - postgres' instead of 'su postgres' without thinking.
Regards, Dave
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Saito | 2006-03-20 09:11:10 | Re: Help |
Previous Message | surya pratap SINGH | 2006-03-20 08:05:45 | installation problem |