user permissions and super user

From: "Yuri A(dot) Kabaenkov" <sec(at)artofit(dot)com>
To: Pgsql-Admin <pgsql-admin(at)postgresql(dot)org>
Subject: user permissions and super user
Date: 2001-12-01 09:34:02
Message-ID: 11310207627.20011201123402@artofit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I have some databases and pg_hba.conf with this content:

------------
local dialer password dialer
host dialer 127.0.0.1 255.255.255.255 password dialer

local helltop password helltop
host helltop 127.0.0.1 255.255.255.255 password helltop

local vote password vote

local partnership password partnership
host partnership 209.224.53.106 255.255.255.255 password partnership
host partnership 127.0.0.1 255.255.255.255 password partnership

local webstats password webstats
------------

How can i create user which users password authrization and can
access/modify/drop/create all these database.

Create languages on databases and so so so.

I've try to add line
local all password all

And in 'all' file i add one user with password, but it doesn't work on
other datbases.

------------
With respect,
Yuri A. Kabaenkov
hellman(at)artofit(dot)com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ragnar Kjørstad 2001-12-01 18:40:25 Re: Clustering high-availability
Previous Message Dado Feigenblatt 2001-12-01 01:09:20 field order