On Jun 14, 2013, at 5:31 AM, Ian Lawrence Barwick wrote:
> Looking at /var/log/auth.log might provide more clues.
as might ssh -vvv
--
Scott Ribe
[email protected]
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list ([email protected]
2013/6/14 Daniel Vázquez :
> Hi here!
>
> Centos 6.4
> Postgres 9.1
>
> I want to automate rsync backups from server1 to server2 via ssh using the
> postgres(linux deamon user) and a pair of private/public keys generated by
> ssh-keygen
>
> I generated the keys in Server1 and copy and added id_rsa.
I've browsed my history of the list, and the Internet for
information
regarding giving the unix 'postgres' user a shell of /bin/false, so
that it cannot be logged into directly. It seems from my research
that
if I set the user's shell to /bin/false it will not prevent the
running of postgres it
On Fri, May 22, 2009 at 9:49 AM, Peter Eisentraut wrote:
> On Friday 22 May 2009 06:51:42 Cliff Pratt wrote:
> > I've browsed my history of the list, and the Internet for information
> > regarding giving the unix 'postgres' user a shell of /bin/false, so
> > that it cannot be logged into directly
On Friday 22 May 2009 06:51:42 Cliff Pratt wrote:
> I've browsed my history of the list, and the Internet for information
> regarding giving the unix 'postgres' user a shell of /bin/false, so
> that it cannot be logged into directly. It seems from my research that
> if I set the user's shell to /bi
On Thu, Jul 31, 2008 at 1:08 PM, Rafael Domiciano
<[EMAIL PROTECTED]> wrote:
> Hi there,
>
> I have a situation that is a bit strange.
> I discovered today that I can login in programs like EMS SQL Manager and in
> the internal software (via ODBC) without using the password for the user.
>
> Exampl
péntek 07 szeptember 2007 18.13 dátummal smiley2211 ezt írta:
> Hello all,
>
> Where do I find the PASSWORDs for users on Postgresql??? It seems
> connections are failing because user PROOT's password is not
> correct - where do I find out what it's set to - do I need to
> change it???
>
> DataObj
Ok...next step is to try to connect remotely from the trusted psql(1) again,
as in
psql -U proot -d databaseName -h hostname -p portNumber
If you can connect, then your listner configuration is working ok (per other
caller's comment). In which case you focus on the application.
Cheers
Medi
On 9
smiley2211 <[EMAIL PROTECTED]> writes:
> Yep, I can connect LOCALLY with no problem...it's when I come through an
> application using this user that I have the connection issue.
Connect locally as superuser and issue an ALTER USER command to set the
user's password to whatever it should be.
Have you checked your pg_hba.conf and postgresql.conf files?
To remote connect you need to "listen" on your external interface (see
postgresql.conf) and you need according settings in pg_hba.conf that allow
you to connect from the ip-address you try it from.
Uwe
On Friday 07 September 2007, s
Yep, I can connect LOCALLY with no problem...it's when I come through an
application using this user that I have the connection issue.
Thanks...Michelle
--
View this message in context:
http://www.nabble.com/Postgres-User-Password-File-tf4402207.html#a12559172
Sent from the PostgreSQL - ad
PG maintains user passwd within itself in a table called pg_shadow.
But based on the error message, it seems like you are having problem
connecting to the server.
Try accessing PG from command line with something like psql(1) as in
psql -U proot -d databaseName
and see what error message do you g
On Tue, 2005-02-22 at 08:07, Zouari Fourat wrote:
> Hello,
> i forgot the postgres user password, how to resolve this problem.
> once i have my postgres user working, how to list all users on the server ?
> thanks a bunch
First off, PostgreSQL stores passwords as md5 hashes (well, the last few
ver
On Tue, Feb 22, 2005 at 15:07:45 +0100,
Zouari Fourat <[EMAIL PROTECTED]> wrote:
> Hello,
> i forgot the postgres user password, how to resolve this problem.
> once i have my postgres user working, how to list all users on the server ?
> thanks a bunch
Edit pg_hba.conf to use trust or ident auth
Hello,
I don't think you are providing the database
name along with psql command as "postgres" user.
bash-2.05$ psql ( is an appropriate syntax.
)
What you see is this=>
bash-2.05$ psqlpsql: FATAL 1: Database
"postgres" does no
15 matches
Mail list logo
