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: