cat pg_hba.conf
# All other connections by UNIX sockets
local all all password
#
# All IPv4 connections from localhost
host all all 127.0.0.1 255.255.255.255 password
# All other connections by UNIX sockets
local all all password
#
# All IPv4 connections from localhost
host all all 127.0.0.1 255.255.255.255 password
# All other connections by UNIX sockets
local all all password
#
# All IPv4 connections from localhost
host all all 127.0.0.1 255.255.255.255 password
su postgres
createuser -adP radovan
CREATE USER uzivatel_krab_cz WITH PASSWORD 'heslo' NOCREATEDB NOCREATEUSER;
CREATE DATABASE uzivatel_krab_cz WITH OWNER = uzivatel_krab_cz
ALTER USER c PASSWORD 'noveheslo';
$result=pg_query($conn, "SELECT * FROM x");
while ($row = pg_fetch_array($result)) {
print_r($row);
}
26.7.2006 1:14:17