Re: [ADMIN] password problems

2011-10-07 Thread Craig Ringer
On 10/07/2011 10:14 PM, Alexander James Spence [axs] wrote: We have updated our server to 9.1 the previous version used am external file for authentication (unix crypt) PostgreSQL's basic auth scheme hasn't changed in a long time, so it's pretty unlikely that the previous version inherently u

[ADMIN] password problems

2011-10-07 Thread Alexander James Spence [axs]
Hi All, We have updated our server to 9.1 the previous version used am external file for authentication (unix crypt), questions: Can I continue to use this file if so how is it referenced in pg_hba.conf? If I want to continue to use unix crypt passwords how do I get them into the database. I

Re: [ADMIN] Password when logging into postgres

2011-09-01 Thread Gabriele Bartolini
Hi Lance, I reinstalled postgres from scratch receintly. I recreated a role with createrole called XYZ. I do not want XYZ to use a password on my local box. How do I set this up so that it will not ask for a password? You have two options: 1) insert a line in ~/.pgpass file in your home dire

Re: [ADMIN] Password when logging into postgres

2011-09-01 Thread Scott Marlowe
On Thu, Sep 1, 2011 at 7:48 AM, Campbell, Lance wrote: > Postgres 9.0.4 > I installed from the visual linux installer > Redhat 6 newest updates > > I reinstalled postgres from scratch receintly.  I recreated a role with > createrole called XYZ.  I do not want XYZ to use a password on my local > bo

[ADMIN] Password when logging into postgres

2011-09-01 Thread Campbell, Lance
Postgres 9.0.4 I installed from the visual linux installer Redhat 6 newest updates I reinstalled postgres from scratch receintly. I recreated a role with createrole called XYZ. I do not want XYZ to use a password on my local box. How do I set this up so that it will not ask for a password? T

Re: [ADMIN] password administration

2010-08-08 Thread Andrzej Zawadzki
On 05.08.2010 22:54, Tom Lane wrote: > Scott Marlowe writes: > >> On Thu, Aug 5, 2010 at 2:20 PM, Craig James >> wrote: >> >>> A better solution is to implement a password-strength algorithm and require >>> people to select decent passwords to begin with. >>> > >> Exactly. If

Re: [ADMIN] password administration

2010-08-05 Thread Bob Lunney
Mark, Look into kerberos. You will have to recompile your server to use it. Bob Lunney --- On Thu, 8/5/10, Mark Steben wrote: > From: Mark Steben > Subject: [ADMIN] password administration > To: pgsql-admin@postgresql.org > Date: Thursday, August 5, 2010, 3:58 PM > > &

Re: [ADMIN] password administration

2010-08-05 Thread Victor Hugo
Correcting I use LDAP + postgresql 2010/8/5 Victor Hugo : > Mark, > > You could use LDAP to? that? > > I use LDAP + apache > > []´s > Victor Hugo > > > > 2010/8/5 Tom Lane : >> "Mark Steben" writes: >>> I would like to set up a facility that enforces password changes for roles >>> After a pre

Re: [ADMIN] password administration

2010-08-05 Thread Victor Hugo
Mark, You could use LDAP to? that? I use LDAP + apache []´s Victor Hugo 2010/8/5 Tom Lane : > "Mark Steben" writes: >> I would like to set up a facility that enforces password changes for roles >> After a predefined period (30 days for instance) when logging into psql >> Or, at the very leas

Re: [ADMIN] password administration

2010-08-05 Thread Scott Marlowe
Also, for reference: http://research.microsoft.com/en-us/people/cormac/ Specifically: http://research.microsoft.com/users/cormac/papers/2009/SoLongAndNoThanks.pdf -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/m

Re: [ADMIN] password administration

2010-08-05 Thread Tom Lane
Scott Marlowe writes: > On Thu, Aug 5, 2010 at 2:20 PM, Craig James > wrote: >> A better solution is to implement a password-strength algorithm and require >> people to select decent passwords to begin with. > Exactly. If you allow simpler passwords that have to be changed you > get things lik

Re: [ADMIN] password administration

2010-08-05 Thread Scott Marlowe
On Thu, Aug 5, 2010 at 2:27 PM, Scott Marlowe wrote: > On Thu, Aug 5, 2010 at 2:20 PM, Craig James > wrote: >> On 8/5/10 12:58 PM, Mark Steben wrote: >>> >>> I would like to set up a facility that enforces password changes for roles >>> After a predefined period (30 days for instance) when loggi

Re: [ADMIN] password administration

2010-08-05 Thread Tom Lane
"Mark Steben" writes: > I would like to set up a facility that enforces password changes for roles > After a predefined period (30 days for instance) when logging into psql > Or, at the very least, send an email out to notify that your current > Password period is about to expire. Usually we sug

Re: [ADMIN] password administration

2010-08-05 Thread Scott Marlowe
On Thu, Aug 5, 2010 at 2:20 PM, Craig James wrote: > On 8/5/10 12:58 PM, Mark Steben wrote: >> >> I would like to set up a facility that enforces password changes for roles >> After a predefined period (30 days for instance) when logging into psql >> Or, at the very least, send an email out to not

Re: [ADMIN] password administration

2010-08-05 Thread Craig James
On 8/5/10 12:58 PM, Mark Steben wrote: I would like to set up a facility that enforces password changes for roles After a predefined period (30 days for instance) when logging into psql Or, at the very least, send an email out to notify that your current Password period is about to expire. Prefe

[ADMIN] password administration

2010-08-05 Thread Mark Steben
Hi postgres gurus: I would like to set up a facility that enforces password changes for roles After a predefined period (30 days for instance) when logging into psql Or, at the very least, send an email out to notify that your current Password period is about to expire. Preferably, I'd like to

Re: [ADMIN] password authentication failed for user postgres

2010-03-04 Thread Major Services
min" or "up2date install > phppgadmin" > Or webmin if you want to admin all server without having to use command > line. http://www.webmin.com/ > > > > > -Original Message- > From: Major Services > To: Iñigo Martinez Lasala > Cc: pgsql-admin@

Re: [ADMIN] password authentication failed for user postgres

2010-03-04 Thread Iñigo Martinez Lasala
admin all server without having to use command line. http://www.webmin.com/ -Original Message- From: Major Services To: Iñigo Martinez Lasala Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] password authentication failed for user postgres Date: Wed, 3 Mar 2010 23:40:39 +0530 When

Re: [ADMIN] password authentication failed for user postgres

2010-03-03 Thread Major Services
sword" since you will > have to enter password for any local operation in your server, but anyway, > it's your decision. > > -Original Message- > From: Major Services > To: Iñigo Martinez Lasala > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] pass

Re: [ADMIN] password authentication failed for user postgres

2010-03-03 Thread Iñigo Martinez Lasala
l-admin@postgresql.org Subject: Re: [ADMIN] password authentication failed for user postgres Date: Wed, 3 Mar 2010 22:41:47 +0530 Thanks. I already have created a user. And can connect to the server through the PgAdmin on my local system. My query now is : Now when I try to connect to the

Re: [ADMIN] password authentication failed for user postgres

2010-03-03 Thread Major Services
reate a new user called dbadmin. It will ask you for a password > for this user and some extra options. Response YES to all. > > Now you can connect remotely with this dbadmin user. > > > > -Original Message- > From: Major Services > To: Iñigo Martinez Lasala

Re: [ADMIN] password authentication failed for user postgres

2010-03-03 Thread Iñigo Martinez Lasala
this user and some extra options. Response YES to all. Now you can connect remotely with this dbadmin user. -Original Message- From: Major Services To: Iñigo Martinez Lasala Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] password authentication failed for user postgres Date: Wed,

Re: [ADMIN] password authentication failed for user postgres

2010-03-03 Thread Major Services
-Original Message- > From: Major Services > To: pgsql-admin@postgresql.org > Subject: [ADMIN] password authentication failed for user postgres > Date: Tue, 2 Mar 2010 14:13:10 +0530 > > Hi, > > 1. I have added listen_addresses = '*' ; in postgresql.c

Re: [ADMIN] password authentication failed for user postgres

2010-03-02 Thread Major Services
st lines of this file ? > > > > > > > > > > > > -Original Message- > > > *From*: Major Services major%20services%20%3cservices.ma...@gmail.com > %3e> > > > > > > > *To*: I?igo Martinez Lasala 3d%3fiso-8859-1%3fq%3fi%3df1igo%3f%

Re: [ADMIN] password authentication failed for user postgres

2010-03-02 Thread Kenneth Marshall
post here last lines of this file ? > > > > > > > > -Original Message- > > *From*: Major Services > > > > > > > *To*: I?igo Martinez Lasala > > > > > > > *Cc*: pgsql-admin@postgresql.org > > *Subject*

Re: [ADMIN] password authentication failed for user postgres

2010-03-02 Thread Major Services
t; imarti...@vectorsf.com> wrote: > Ah... ok. > In /var/lib/pgsql you will find a file called pgstartup.log > Could you post here last lines of this file ? > > > > -Original Message- > *From*: Major Services > > > > *To*: Iñigo Martinez Lasala &

Re: [ADMIN] password authentication failed for user postgres

2010-03-02 Thread Iñigo Martinez Lasala
Ah... ok. In /var/lib/pgsql you will find a file called pgstartup.log Could you post here last lines of this file ? -Original Message- From: Major Services To: Iñigo Martinez Lasala Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] password authentication failed for user postgres

Re: [ADMIN] password authentication failed for user postgres

2010-03-02 Thread Major Services
oes not have ident enabled... > > local all postgres trust > > > > -Original Message- > *From*: Major Services > > > > *To*: Iñigo Martinez Lasala > > > > *Subject*: Re: [ADMIN] password authentication failed for user postgres > *Date*: T

Fwd: [ADMIN] password authentication failed for user postgres

2010-03-02 Thread Major Services
t place to your pg_hba.conf > local all postgres ident sameuser > > > Reload postgresql and launch createuser as postgres user. > > > -Original Message- > From: Major Services > To: pgsql-admin@postgresql.org > Subject: [ADMIN] passwor

Re: [ADMIN] password authentication failed for user postgres

2010-03-02 Thread Iñigo Martinez Lasala
r Reload postgresql and launch createuser as postgres user. -Original Message- From: Major Services To: pgsql-admin@postgresql.org Subject: [ADMIN] password authentication failed for user postgres Date: Tue, 2 Mar 2010 14:13:10 +0530 Hi, 1. I have added listen_addresses

[ADMIN] password authentication failed for user postgres

2010-03-02 Thread Major Services
Hi, 1. I have added listen_addresses = '*' ; in postgresql.conf 2. And have made the following changes to pg_hba.conf local DATABASEUSER METHOD localsamegroup all password hostDATABASEUSERCIDR-ADDRESS METHOD [OPTION] host all all

[ADMIN] password authentication failed

2009-12-16 Thread Sam Jas
I am newbee for Bucardo. Whenever i am trying to add database or try to look into show all command. It shows me following error. Connecting to database 'bucardo' as user 'bucardo' DBI connect('dbname=bucardo;port=5433','bucardo',...) failed: FATAL:  password authentication failed for user "buc

Re: [ADMIN] password strength verification

2008-12-18 Thread Chris Browne
rexma...@yahoo.com (Rex Mabry) writes: > If a company requires a password to be a combination of letters, > numbers and special characters. Oracle has a profile setting with a > password verify function that can be used to specify a function > that can do this.  Does postgres have a setting or 

[ADMIN] password strength verification

2008-12-18 Thread Rex Mabry
Hi, If a company requires a password to be a combination of letters, numbers and special characters. Oracle has a profile setting with a password verify function that can be used to specify a function that can do this.  Does postgres have a setting or function to verify and enforce a password po

[ADMIN] Password recommendations for an appliance

2008-07-11 Thread niall el-assaad
Hi, I'm developing an appliance that runs postgresql and will be provided to many people. I am wondering on the best way of protecting the database user account. At the moment the account has no password on it, to me this means that the only people who can connect are the application (PHP running

[ADMIN] password management

2008-02-06 Thread antonio freitas
Hi, I need to manage the passwords in my database. My plan is to: - control the minimum password size; - Disable the user after the 5th wrong try to connect; - check the passwords characters against a pattern; - monitor last connections, in order to disable users that don´t

Re: [ADMIN] Password Policy

2007-02-10 Thread Christopher Browne
In the last exciting episode, [EMAIL PROTECTED] ("Ezequias Rodrigues da Rocha") wrote: > Hi list (my first post), > > Is there any password polity that postgresql implement ? No, that would be a serious mistake, as it would prevent people from having local policies that diffe

Re: [ADMIN] Password Policy

2007-02-10 Thread Ezequias Rodrigues da Rocha
Hi list (my first post), Is there any password polity that postgresql implement ? It is possible to put a set all no administrators passwords to = '123456' from times and times ? Has anyone implement a dinamic password autentication (the password changes according the date/month etc of a day )

Re: [ADMIN] password authentication failed (postgresql v8.1.4)

2006-06-17 Thread David
On Sat, Jun 17, 2006 at 01:41:13PM +0200, Andrea Gozzi wrote: > Hi. > I have been upgrading my PG server from version 7.4 (debian sarge > binary) to v8.1.4 (source installation). I see in subsequent messages that you got your particular problem worked out, but if you prefer to stick with Debian bi

Re: [ADMIN] password authentication failed (postgresql v8.1.4)

2006-06-17 Thread Andrea Gozzi
June 2006 12:41 pm > > To: pgsql-admin@postgresql.org > > Subject: [ADMIN] password authentication failed (postgresql v8.1.4) > > > > Hi. > > I have been upgrading my PG server from version 7.4 (debian sarge > > binary) to v8.1.4 (source installation). > &g

Re: [ADMIN] password authentication failed (postgresql v8.1.4)

2006-06-17 Thread Andy Shellam
-admin- > [EMAIL PROTECTED] On Behalf Of Andrea Gozzi > Sent: 17 June 2006 12:41 pm > To: pgsql-admin@postgresql.org > Subject: [ADMIN] password authentication failed (postgresql v8.1.4) > > Hi. > I have been upgrading my PG server from version 7.4 (debian sarge > binary)

Re: [ADMIN] password authentication failed (postgresql v8.1.4)

2006-06-17 Thread Andy Shellam
--Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-admin- > [EMAIL PROTECTED] On Behalf Of Andrea Gozzi > Sent: 17 June 2006 12:41 pm > To: pgsql-admin@postgresql.org > Subject: [ADMIN] password authentication failed (postgresql v8.1.4) > > Hi. > I have been upgr

[ADMIN] password authentication failed (postgresql v8.1.4)

2006-06-17 Thread Andrea Gozzi
Hi. I have been upgrading my PG server from version 7.4 (debian sarge binary) to v8.1.4 (source installation). The installation procedure went fine but I can't log into the database with another role/user than 'postgres'. This is my pg_hba.conf, that I was succesfully using with v7.4: # Database

Re: [ADMIN] password authentication with external passwd file

2005-08-29 Thread Tom Lane
Jason Stone <[EMAIL PROTECTED]> writes: > out of curiosity, why was the secondary password file capability removed? You'd have to look into the pghackers archives for details, but my recollection is that it didn't play nicely with other features that we wanted to add. > I really liked the simplic

Re: [ADMIN] password authentication with external passwd file

2005-08-29 Thread Jason Stone
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I would like to know first, if I'm mistaken, or if external passwd files are now specified in some other way, or must be enabled at compile time or something like that; ie, am I doing something wrong? The 7.3 Release Notes have the following items

Re: [ADMIN] password authentication with external passwd file

2005-08-27 Thread Michael Fuhr
On Sat, Aug 27, 2005 at 01:31:25AM -0700, Jason Stone wrote: > I would like to know first, if I'm mistaken, or if external passwd files > are now specified in some other way, or must be enabled at compile time or > something like that; ie, am I doing something wrong? The 7.3 Release Notes have t

[ADMIN] password authentication with external passwd file

2005-08-27 Thread Jason Stone
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello all. I am currently running postgresql-7.2, and I have my pg_hba.conf configured to use password authentication with external passwd files. eg: pg_hba.conf: local db1 all password db1.pwd host db1 all 127.0.0.1 255.

Re: [ADMIN] Password and batch process

2005-08-26 Thread John DeSoi
On Aug 26, 2005, at 3:57 AM, Bouchard Sylvie wrote: I use Postgres 8.0.2, Windows 2000. My batch file use pg_dump for backup my database. I specifie a superuser for connecting to server. How must I make to avoid putting the password in light in the order? http://www.postgresql.org/docs/8.0

[ADMIN] Password and batch process

2005-08-26 Thread Bouchard Sylvie
Hi,  I use Postgres 8.0.2, Windows 2000. My batch file use pg_dump for backup my database. I specifie a superuser for connecting to server. How must I make to avoid putting the password in light in the order? Thank's Sylvie

Re: [ADMIN] Password with libpq

2004-06-28 Thread Peter Eisentraut
Tony and Bryn Reina wrote: > Thanks Tom. I found the relevant bit of code in the psql files. Looks > like it's just a simple loop that compares the error with the phrase > "fe_sendauth: no password supplied" and then prompts for the password > and tries again. Of course, if someone in the future de

Re: [ADMIN] Password with libpq

2004-06-28 Thread Tony and Bryn Reina
e error message, then the code gets broke. I doubt that's likely however. -Tony - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Tony Reina" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, June 28, 2004 12:12 AM Sub

Re: [ADMIN] Password with libpq

2004-06-27 Thread Tom Lane
[EMAIL PROTECTED] (Tony Reina) writes: > However, what about in the general case where my client program > doesn't know if a password is required or not. Is there any libpq > function to query the server if a password is required? Perhaps, > there's a return value for PQconnectdb which would tell m

[ADMIN] Password with libpq

2004-06-27 Thread Tony Reina
I'm setting my PostgreSQL server to demand md5 encrypted passwords from users. In my C programs (using libpq as the interface), it's no big deal to pass the password through PQconnectdb. However, what about in the general case where my client program doesn't know if a password is required or not.

Re: [ADMIN] password accessibility

2004-04-12 Thread Peter Eisentraut
Greg Steffensen wrote: > I'd like to construct a view containing the usernames, passwords, etc > in jabber's required format, but system catalog information doesn't > seem to be accessible to views. That is not correct. ---(end of broadcast)--- TIP

[ADMIN] password accessibility

2004-04-12 Thread Greg Steffensen
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm in the process of integrating a jabber server into a postgresql-based web portal. The portal has a separate postgresql user for every registered user of the site. Authentication on the site is easy enough; the site just attempts to connect to the

Re: [ADMIN] Password Encryption

2003-01-26 Thread Bruce Momjian
Yes, it is. We now recommend MD5, and have since 7.2. The only way to use crypt still is to store the password UNENCRYPTED in ALTER USER. --- Raúl Gutiérrez Sánchez wrote: > I have tried to perform a cryp authentication bu

[ADMIN] Password Encryption

2003-01-22 Thread Raúl Gutiérrez Sánchez
I have tried to perform a cryp authentication but it seems not to work if the user passwords are stored md5-encrypted in the database. Is this behaviour normal?. Regards, Raul Gutierrez ---(end of broadcast)--- TIP 2: you can get off all lists at on

Re: [ADMIN] Password authentication disabled due to MD5 usage

2003-01-09 Thread Peter Schuller
> The recommendation is to use MD5. However, 7.3.1 has a fix so you can > use 'password' again. Ok - thanks! -- / Peter Schuller, InfiDyne Technologies HB PGP userID: 0xE9758B7D or 'Peter Schuller <[EMAIL PROTECTED]>' Key retrival: Send an E-Mail to [EMAIL PROTECTED] E-Mail: [EMAIL PROTECTED]

Re: [ADMIN] Password authentication disabled due to MD5 usage

2003-01-09 Thread Bruce Momjian
The recommendation is to use MD5. However, 7.3.1 has a fix so you can use 'password' again. --- Peter Schuller wrote: > Hello, > > since I upgraded PostgreSQL it now stores passwords in MD5 format. When > I try connecting

[ADMIN] Password authentication disabled due to MD5 usage

2003-01-09 Thread Peter Schuller
Hello, since I upgraded PostgreSQL it now stores passwords in MD5 format. When I try connecting using password authentication, i get: Jan 9 12:22:24 prometheus postgres[28540]: [2] LOG: Password is stored MD5 encrypted. 'password' and 'crypt' auth methods cannot be used. Now, if password and

Re: [ADMIN] password encryption

2002-10-03 Thread Joe Conway
Jodi Kanter wrote: > We are currently using the pg_passwd utility to encrypt passwords. > Someone here told me that I can now encrypt passwords within postgresql > so that they are not stored in plain text in the pg_shadow file. > Is this true? I cannot seem to find any mention of it in my postg

[ADMIN] password encryption

2002-10-03 Thread Jodi Kanter
We are currently using the pg_passwd utility to encrypt passwords. Someone here told me that I can now encrypt passwords within postgresql so that they are not stored in plain text in the pg_shadow file. Is this true? I cannot seem to find any mention of it in my postgresql books but it's qu

Re: [ADMIN] Password recover

2002-06-25 Thread Chad R. Larson
On Sat, 2002-06-22 at 22:03, Peter Arzamendi wrote: > Is there a way to recover the sa password? > > Thanks, > Pete Do you need to know what the password was, or just access password protected databases? -crl -- Chad R. Larson (CRL15) 602-953-1392 Brother, can you paradigm? [

Re: [ADMIN] Password recover

2002-06-24 Thread Aaron Spiteri
Title: Re: [ADMIN] Password recover I had the same problem a while a go the way I fixed was like this: Log in has root user on the server. Swith to postgres user "su postgres" Make a back up of your pg_hda.conf file. On RH this is in /var/lib/pgsql/data Alter the pg_hda.con

Re: [ADMIN] Password recover

2002-06-24 Thread Larry Rosenman
On Sat, 2002-06-22 at 22:03, Peter Arzamendi wrote: > Is there a way to recover the sa password? What version of PostgreSQL? > > Thanks, > Pete > -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Stea

[ADMIN] Password recover

2002-06-24 Thread Peter Arzamendi
Title: Password recover Is there a way to recover the sa password? Thanks, Pete

Re: [ADMIN] Password file for autent

2001-07-19 Thread Edipo Elder Fernandes de Melo
Em 19 Jul 2001, Rashid N. Achilov escreveu: >> local all password >psql tried to check password user 'mane' by system table pg_shadow instead >of >the file users. You have to change first line to "local all password users" But I was planing use the file "users" to aute

[ADMIN] Password file for autent

2001-07-18 Thread Edipo Elder Fernandes de Melo
Ave all Admins, I searched the list for before this, but i didn't find an answer. I'm doing all as the script (i think) and I don't get autentication to user. My pg_hab.conf is (10.3.128.222 is the localhost): localall password

Re: [ADMIN] password long

2001-05-30 Thread Mike Castle
On Thu, May 31, 2001 at 12:01:22AM +0200, Tomasz Misterka wrote: > Hi, > > When I gave any user password longer than eight digits, the user can enter > the base with only first eight digits of the password. > > Is there any possibility to have longer password? It looks like it uses the standar

[ADMIN] password long

2001-05-30 Thread Tomasz Misterka
Hi, When I gave any user password longer than eight digits, the user can enter the base with only first eight digits of the password. Is there any possibility to have longer password? Tomasz Misterka ---(end of broadcast)--- TIP 4: Don't 'kill

[ADMIN] password politic

2001-05-18 Thread Miguel Gonzalez
Dear All, I am trying to configure the access to the postgreSQL server through web. I would like that someone could give a general idea of how the password politic works in PostgreSQL. Let me explain what I have tried so far. I want to do access to PostgreSQL using password encryption. What

Re: [ADMIN] password

2001-04-16 Thread Oliver Elphick
"Oliver Elphick" wrote: > >I use pgaccess and I have created new users with password ... >Access control is defined by the text file pg_hba.conf. The default setting >in this file is > > local all trust > >which means that anyone on the local machine can log into any PostgreSQL

Re: [ADMIN] password

2001-04-16 Thread Oliver Elphick
"[EMAIL PROTECTED]" wrote: >I use postgresql 7.x on red hat 7.0 > >I use pgaccess and I have created new users with password >but when I want to open a database with a new user which normally needs a pa >ssword, if I don't assign the password, the database is open without it. > >

[ADMIN] password

2001-04-16 Thread [EMAIL PROTECTED]
I use postgresql 7.x on red hat 7.0 I use pgaccess and I have created new users with password but when I want to open a database with a new user which normally needs a password, if I don't assign the password, the database is open without it. Why ? _

Re: [ADMIN] password

2000-07-27 Thread Wuttipong Suvaphrom
Thanks for answering my question.   May I ask a bit more ? Do you know how to use ident in pg_hba.conf ? I don't know how it works. I use pg_access to design databases and link it  together by foreign keys. So I can't use Select * from sampletable ; It said  no relation. I must use select t0

[ADMIN] password

2000-07-27 Thread Wuttipong Suvaphrom
Hi all,   when I create users , I use creatuser user1. Is that user(user1) will be in file pg_shadow ? How can I create password for that user ? and How can I encrypt text in  my databases ?   thanks a lot.      

[ADMIN] password encryption

2000-07-21 Thread Silesky Marketing Inc, Support
Hello, I want to encrypt passwords with Postgresql the way mySQL does it with : UPDATE user SET Password=PASSWORD('new_password') WHERE user='root'; How can I do that ? Thanks a lot, Laurent

[ADMIN] Password crypted storage utilisation

2000-05-30 Thread Loïc TREGOUËT
    Hie , hope someone can help me       I 'm trying to secure my database so i would like to use crypted password for authentification. But if i do this with pg_hba.conf like : local  all    crypt passwords are still stored in clear ! I don't wan't that superu

Re: [ADMIN] password

2000-05-27 Thread Oliver Elphick
"Vladimir V. Zolotych" wrote: >How can I set password on existing database ? template1=# \help alter user Command: ALTER USER Description: Modifies user account information Syntax: ALTER USER username [ WITH PASSWORD 'password' ] [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER

[ADMIN] password

2000-05-27 Thread Vladimir V. Zolotych
Hello all, Very simple question if you please How can I set password on existing database ? Thanks! --  Vladimir Zolotych [EMAIL PROTECTED]  

[ADMIN] Password auth

2000-03-20 Thread dizzy
Hi everyone, I have a postgresql 6.5.3 installed on a redhat machine (base 6.0 but the rpms are from 6.1). Until now everything works fine with it (even www+php access). Last night I encountered this problem. I want to be able to connect to the database server using "password" as the authentifica

Re: [ADMIN] Password

2000-01-14 Thread Brad Bonkoski
Hello... You are able to make users authenticate by setting up your pg_hba.conf file. Instead of trust at the end use password. I would read the manual on security because it gives you some pretty clear axample f what you probably want. Hope this helps -Brad "Strand Johan F." wrote: > Hi ! > >

[ADMIN] Password

2000-01-14 Thread Strand Johan F.
Hi ! Is it possible to configure the postgresql database server to require password when you log in from the same host as the databse server ? in my case I have a java-program that access the database through JDBC but it doesen't matter what I type in passwd field as long as the user-id are cor

Re: [ADMIN] Password protected databases and automated backups

1999-08-03 Thread Dmitry Morozovsky
On Tue, 3 Aug 1999, Herouth Maoz wrote: HM> > Yes, surely, I meant precisely this situation. I have looked through HM> > sources of pg_dump, but have no time to patch it to achieve desired HM> > effect :) HM> HM> I have a feeling your question is really "How do I have the password HM> entered if

Re: [ADMIN] Password protected databases and automated backups

1999-08-03 Thread Herouth Maoz
At 16:09 +0300 on 03/08/1999, Dmitry Morozovsky wrote: > This is not very useful solution, as the script shoud be readable at least > for owner -- but we can make simple C program, compile it and make > executable only (0100). I'm not sure how bad readability to the owner would be. Anyway, I wa

Re: [ADMIN] Password protected databases and automated backups

1999-08-03 Thread Herouth Maoz
At 00:53 +0300 on 03/08/1999, Dmitry Morozovsky wrote: > Yes, surely, I meant precisely this situation. I have looked through > sources of pg_dump, but have no time to patch it to achieve desired > effect :) I have a feeling your question is really "How do I have the password entered if there i

Re: [ADMIN] Password protected databases and automated backups

1999-08-02 Thread Peter Eisentraut
On Tue, 3 Aug 1999, Dmitry Morozovsky wrote: > On Mon, 2 Aug 1999, Peter Eisentraut wrote: > > PE> > How can I organize automated database dumping for passord protected > PE> > database? > PE> If you're implying something like "How do I get around entering a > PE> password?", that won't be solva

Re: [ADMIN] Password protected databases and automated backups

1999-08-02 Thread Dmitry Morozovsky
DM> PE> A different solution would be to backup the $PGDATA/base directory using DM> PE> regular file backup methods. That wouldn't be a dump, so it depends on DM> PE> your particular needs. DM> DM> This may not have the desired effect, as the database may be not in DM> consistent state. Of co

Re: [ADMIN] Password protected databases and automated backups

1999-08-02 Thread Dmitry Morozovsky
On Mon, 2 Aug 1999, Peter Eisentraut wrote: PE> > How can I organize automated database dumping for passord protected PE> > database? PE> If you're implying something like "How do I get around entering a PE> password?", that won't be solvable so easily. Possibly you want to use PE> ident authenti

Re: [ADMIN] Password protected databases and automated backups

1999-08-02 Thread Peter Eisentraut
On Mon, 2 Aug 1999, Dmitry Morozovsky wrote: > How can I organize automated database dumping for passord protected > database? If you're implying something like "How do I get around entering a password?", that won't be solvable so easily. Possibly you want to use ident authentication for that pa

[ADMIN] Password protected databases and automated backups

1999-08-02 Thread Dmitry Morozovsky
Hi there, How can I organize automated database dumping for passord protected database? Any suggestions are welcome. Thank you in advance. Sincerely, D.Marck [DM5020, DM268-RIPE, DM3-RIPN]

Re: [ADMIN] password administration

1998-12-17 Thread Adam Maddock
Hmm... that doesn't work on my system because my system's logon/passwd commands use a different encryption altorhythm than Postgres. I wonder if there is a way to change one or the other's scheme. Did you have to hack anything or did it work "out-of-the-box"? My Linux kernel is 2.0.34 and my di

Re: [ADMIN] password administration

1998-12-17 Thread Charles Curley
I don't know about secure but what I've done is linked the pg_passwd file to /etc/passwd and then people remote ODBC user can change their database password via the passwd command (or yppasswd). I've got a RH 5.0 system running without shadowed password but with NIS. I'm curious what people think

[ADMIN] password administration

1998-12-17 Thread Adam Maddock
Hi All, As one who is fairly new (within the last two months) to Postgre, I've looked through the Archives for this list a bit and have seen this issue addressed a number of times, but no strong solutions posted. Has anybody devised a good/secure way of allowing users to control their own passwo

Re: [ADMIN] Password authentication failing...?

1998-08-10 Thread Jeremiah Davis
you need to add the other users as postgres users.. createuser (username) On Mon, 10 Aug 1998, Drew Hamilton wrote: > Hi there! > > I've just installed Postgres and now I'm having problem with authentication. > Everything works properly when I log on "directly" (logged on to UNIX as > the sa

[ADMIN] Password authentication failing...?

1998-08-10 Thread Drew Hamilton
Hi there! I've just installed Postgres and now I'm having problem with authentication. Everything works properly when I log on "directly" (logged on to UNIX as the same user as I'm logging onto Postgres): [postgres@urd pgsql]$ psql ichallenge Welcome to the POSTGRESQL interactive sql monitor: