Re: weird problem with pgadmin & postgres on debian - Mailing list pgadmin-support

From Alessandro @ GMail
Subject Re: weird problem with pgadmin & postgres on debian
Date
Msg-id 441C428C.2090606@gmail.com
Whole thread Raw
In response to Re: weird problem with pgadmin & postgres on debian  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgadmin-support
mmm i think you're right and it's not the same installation as i have not defined the PGDATA environment variable yet,
soi don't know what he started at boot time...(i run the db with the -D option right now)<br /><br /> another thing i
forgotto 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? <br />
theni changed the folder to /usr/local/pgsql/data/ but pgadmin refused still to connect. Only after i slaughtered
/etc/init.d/postgresql-8.1i was able to connect with pgadmin...<br /><br /> thx<br /> Alessandro<br /><br /> Dave Page
wrote:<blockquote cite="mid006d01c64a92$a8eaaeb0$6a01a8c0@valehousing.co.uk" type="cite"><pre wrap="">Are you sure
you'restarting the same installation/cluster? Manually/init shouldn't make any difference if so.
 

Regards, Dave

-----Original Message-----
From: "Alessandro @ GMail"<a class="moz-txt-link-rfc2396E"
href="mailto:neurotrotter@gmail.com"><neurotrotter@gmail.com></a>
Sent: 18/03/06 13:12:01
To: <a class="moz-txt-link-rfc2396E"
href="mailto:pgadmin-support@postgresql.org">"pgadmin-support@postgresql.org"</a><aclass="moz-txt-link-rfc2396E"
href="mailto:pgadmin-support@postgresql.org"><pgadmin-support@postgresql.org></a>
Subject: Re: [pgadmin-support] weird problem with pgadmin & postgres on debian

ok, i fixed it by removing the postmaster daemon from init.d and starting postgres manually every time i need it, don't
nowwhy but it works, maybe it's a problem of user rights, but i'm too noob to know :P
 





----------------------------------------------------------------

hello there, (it's the first time i use a mailing list...wow!)So, here's my problem: I've installed postgresql on
debianas well as pgadmin(everything updated to last version).Now, when i try to access my server on localhost with
pgadmin,i cannot enter because it asks me the password. But i have no password, as it's just a first-time
learning-purposeinstall! If i simply leave the password field empty, it rejects my login( "Error connecting to the
server:fe_sendauth: no password supplied"). But, if i try to access the server with 'psql testdatabase' from a
terminal,i am able to enter, and work normally.I've also installed postgresql & pgadmin on windows xp (database
differentfrom the linux one) and pgadmin acts normally, letting me login and managing databases without any
problem.What'swrong?thx
 






-----Unmodified Original Message-----
ok, i fixed it by removing the postmaster daemon from init.d and starting postgres manually every time i need it, don't
nowwhy but it works, maybe it's a problem of user rights, but i'm too noob to know :P
 





----------------------------------------------------------------

hello there, (it's the first time i use a mailing list...wow!)So, here's my problem: I've installed postgresql on
debianas well as pgadmin(everything updated to last version).Now, when i try to access my server on localhost with
pgadmin,i cannot enter because it asks me the password. But i have no password, as it's just a first-time
learning-purposeinstall! If i simply leave the password field empty, it rejects my login( "Error connecting to the
server:fe_sendauth: no password supplied"). But, if i try to access the server with 'psql testdatabase' from a
terminal,i am able to enter, and work normally.I've also installed postgresql & pgadmin on windows xp (database
differentfrom the linux one) and pgadmin acts normally, letting me login and managing databases without any
problem.What'swrong?thx
 



 </pre></blockquote><br />

pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: weird problem with pgadmin & postgres on debian
Next
From: "Andrew Madu"
Date:
Subject: postgreSQL txt dump restore