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.
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.pub to
/var/lib/pgsql/.ssh/authorized_keys i
Not sure if this is the right list, and you probably know about this
already, was wondering if there's a fix imminent:
After installing postgresql-9.0.1-1-windows.exe on 64-bit windows 7, the
'postgres' user is visible as a new user that allows screen logins. I
looked into this and it's becau
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
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 itself
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
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.
Example:
Configuration on the ODBC:
datasource: postgres
database: Postgres
server: "IP"
user:
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
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???
DataObjects_Users : CONNECT :
a:1:{s:32:"b8c77e08e3d43ac04152a2db76d9728a";O:8:"DB
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???
DataObjects_Users : CONNECT :
a:1:{s:32:"b8c77e08e3d43ac04152a2db76d9728a";O:8:"DB
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 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
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index
semicolon
to execute query \q to quit
template1=# \q
regards,
Rakesh P.
- Original Message -
From:
Anagha
Joshi
To: [EMAIL PROTECTED]
Sent: Friday, May 30, 2003 10:26 AM
Subject: [ADMIN] postgres user
Hi
Hi,
I’ve installed Postgres-7.3.2 on Linux. When I’m
trying to start ‘psql’ as user ‘postgres’, I found error :
psql: FATAL 1: Database
"postgres#" does not exist in the system catalog.
/etc/passwd shows entry like this:
postgres:x:1078:1:PostgreSQL-administrator:/usr/local/pgsql:/
Hello,
suddenly I find that the postgres user no longer has permission to
create new users and databases.
What do I do? :) I haven't fiddled with it at all AFAIK, so I can't
imagine what triggered the problem.
I'm *about* to fiddle though. Any hints on making PostgreSQL secure in a
multi-user e
24 matches
Mail list logo
