Also you need to specify the file name of password file in AUTH_ARGUMENT
parameter in pg_hba.conf file.
TYPE DATABASEIP_ADDRESS MASK
AUTH_TYPE AUTH_ARGUMENT
Local all
password
Title: How to create a user with password
> Hi, all:
>
> In the file of pg_hba.conf, I give the following parameter:
>
> TYPE DATABASE IP_ADDRESS MASK
> AUTH_TYPE AUTH_ARGUMENT
> Local all
Title: How to create a user with password
Hi, all:
In the file of pg_hba.conf, I give the following parameter:
TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE AUTH_ARGUMENT
Local all password
RedHat 7.2
PostgreSQL 7.2
Dual Pentium III, with 256MB RAM (really need 512MB as a minimum), SCSI
drives.
4 Million insert in one month and still going.
Remeber to VACUUM ANALYZE (very important for the planner). Use the
tuning tips to tune at least shared_buffers, and sort_mem.
On Wed, 3
Also you need to specify the file name of password file in AUTH_ARGUMENT
parameter in pg_hba.conf file.
TYPE DATABASEIP_ADDRESS MASK
AUTH_TYPE AUTH_ARGUMENT
Local all
password
Title: RE: [ADMIN] How to create a user with password
use the utility pg_passwd. The argument is the file that will hold the passwords
$pg_passwd passfile
Username:postgres
New password:
Re-enter new password:
-Original Message-
From: Web Administrator [mailto:[EMAIL PROTECTED]
On Wed, Apr 03, 2002 at 04:02:11PM -0800, Chris Pesko wrote:
> Thanks. That seems a better way to go.
The PostgreSQL docs is your good friend :-)
> At 03:47 PM 4/3/02 -0800, Stephan Szabo wrote:
>
> >You might want to try the FM format on the to_char string...
> >sszabo=# select to_date(to_ch
