search for: pg_user

I have a shell script (sh) where I create a user and import data to a postgres database <snip> su -c "createuser -A -D -P $PG_user" postgres su -c "psql -d$PG_database -h localhost -U$PG_user -W -f postgresql.sql " postgres </snip> when the script executes those command, it ask for a password, how could I do this without have to enter the passwd, I would like that it reads the password from a variabel, th...

...g any output and the logs got filled with some SELinux errors. So I turned off SELinux completely (and rebooted). Now I'm getting the following error message: # pg_dump -U postgres database > database.out pg_dump: SQL command failed pg_dump: Error message from server: ERROR: relation "pg_user" does not exist pg_dump: The command was: SELECT (SELECT usename FROM pg_user WHERE usesysid = datdba) as dba, pg_encoding_to_char(encoding) as encoding, datpath FROM pg_database WHERE datname = 'database' Thank you for your help! Andy

> -----Original Message----- > From: centos-bounces at centos.org [mailto:centos-bounces at centos.org] On > Behalf Of Andy Masiar > Sent: Thursday, April 28, 2005 2:41 PM > To: centos at centos.org > Subject: [CentOS] relation "pg_user" does not exist error when > runningpg_dump > > Hi, > > I'm trying to move a postgres database to another server and I ran > into some weird problems. Pg_dump command was not giving any output > and the logs got filled with some SELinux errors. So I turned off > S...

...CREATE DATABASE bash-3.1$ exit exit Then, I installed phpPgAdmin rpm. [root at LinuxBox etc]# rpm -qa |grep phpPgAdmin phpPgAdmin-4.0.1-1 Then, After I logined to phpPgAdmin via web browser as below http://ipaddress/phpPgAdmin/ Then, I got below erros. *SQL error:* ERROR: relation "pg_user" does not exist *In statement:* SELECT usesuper FROM pg_user WHERE usename='test' PostgreSQL 7.4.16 running on :5432 -- You are logged in as user "test", 11th May, 2007 3:12PMSQL<http://124.43.200.74/phpPgAdmin/sqledit.php?server=%3A5432&action=sql>| Find<http:...

...ox. i have been able to recreate my users, set up the permissions, and restore the database dump. also, i can already log-in to my databases. there is, however, one annoying problem. whenever i type \du (or \d or \l) on the psql prompt, i get the following error: ERROR: relation "pg_catalog.pg_user" does not exist after some googling, i'm beginning to suspect that this is a SELinux issue. i then try to disable SELinux on the postgresql daemon by doing: # setsebool postgresql_disable_trans true that does not work unfortunately as i'm still stuck with the same error. while i ca...

In a RoR application, is it possible to have individual userids associated with particular sessions employed to establish their related connections to the postgresql DBMS backend and, if so, is this design desireable? What are the implications for performance and future deployment limitations? The idea behind this question is that in our application certain tables require that the last

...ket: type: listen client: path: /var/spool/postfix/private/auth mode: 432 user: postfix group: postfix plugin: quota: maildir grep -v '^ *\(#.*\)\?$' /etc/dovecot-sql.conf driver = pgsql connect = host=<pg_server_ip> dbname=<pg_dbname> user=<pg_user> password=<pg_password> default_pass_scheme = PLAIN password_query = SELECT jm || '@%d' as user, password FROM usera where jm = '%n' and forbid = 'N' and ( '%d' = 'our.domain1' or '%d' = 'our.domain2' ) Can someone shed a light o...