similar to: postgres erros on RHEL 4

> -----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

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 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

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

Anyone been able to get pgadmin3 installed on CentOS-4 ? The WxGTK2 stuff makes it impossible for me to get installed from RPM/SRPM from their site and likewise, couldn't rebuild from Fedora SRPMS either. I figure between Jim and Owen and ???, somebody might have succeeded where I would be doomed. I can get around with phppgadmin but pgadmin3 is pretty cool. Thanks Craig

I remember to see something about that in shorewall.net some time ago, but I could not find it today ... The case : Debian Etch, Shorewall 3.2.6, squid3 and Apache 2 . The first 3 where already running fine for some time ... Now I need to setup an Apache server to allow some web mannagement, things like PHPsysinfo, phppgadmin, just for internal net, no web access . but port 80 is redirected to

OS - CentOS4 PostgreSQL = 8.0.3 I think that I need to locate a custom pam module to use in pg_hba.conf that will allow phpPgAdmin to authenticate users against /etc/password (shadow). I cannot seem to find a straight forward reference to such a beast either in the documentation or on the web. The pam modules that I have found through google seem to be intended to allow one to authenticate

hello everyone, i'm trying to run a postgresql service on my newly-installed centos4 box. 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

Hello, This post is to announce the latest 0.2 release of RailsDB: Q. What? A. RailsDB is a web application written in Ruby using the Ruby on Rails web framework. RailsDB provides a generic interface to popular open source databases such as MySQL, PostgreSQL, and SQLite. The RailsDB project is currently under heavy development and seeking more developers to assist. Q. Where? A.

Hi, We've observed frequent auth failure recently from the SquirrelMail frontend. The imap server is the dovecot-1.0.7-2 from Centos 5.2. The auth backend is a pgsql database on another server. The only way to make it work is to restart the dovecot, though sometimes it'll recover automatically, but you don't know when. At first we thought there might be a network problem, but we

CentOS Errata and Security Advisory 2007:0064 https://rhn.redhat.com/errata/RHSA-2007-0064.html The following updated files have been uploaded and are currently syncing to the mirrors: s390: updates/s390/RPMS/postgresql-7.4.16-1.RHEL4.1.s390.rpm updates/s390/RPMS/postgresql-contrib-7.4.16-1.RHEL4.1.s390.rpm updates/s390/RPMS/postgresql-devel-7.4.16-1.RHEL4.1.s390.rpm

Send CentOS-announce mailing list submissions to centos-announce at centos.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.centos.org/mailman/listinfo/centos-announce or, via email, send a message with subject or body 'help' to centos-announce-request at centos.org You can reach the person managing the list at centos-announce-owner at centos.org When

Hi All, I want to know thoughts on if I am being to paranoid/security conscious. CentOS 5.6, Apache, MySQL, running an Firewall in front of everything and obviously the built-in firewall on the box. I have ssh on a different port and starting to use Keys instead of password authentication. I host an intensive website and I am getting about 150 unique visitors per day. What I am seeing is

CentOS Errata and Security Advisory 2007:0064 https://rhn.redhat.com/errata/RHSA-2007-0064.html The following updated files have been uploaded and are currently syncing to the mirrors: x86_64: postgresql-7.4.16-1.RHEL4.1.x86_64.rpm postgresql-contrib-7.4.16-1.RHEL4.1.x86_64.rpm postgresql-devel-7.4.16-1.RHEL4.1.x86_64.rpm postgresql-docs-7.4.16-1.RHEL4.1.x86_64.rpm

CentOS Errata and Security Advisory 2007:0064 https://rhn.redhat.com/errata/RHSA-2007-0064.html The following updated files have been uploaded and are currently syncing to the mirrors: i386: postgresql-7.4.16-1.RHEL4.1.i386.rpm postgresql-contrib-7.4.16-1.RHEL4.1.i386.rpm postgresql-devel-7.4.16-1.RHEL4.1.i386.rpm postgresql-docs-7.4.16-1.RHEL4.1.i386.rpm

CentOS Errata and Security Advisory 2007:0064 https://rhn.redhat.com/errata/RHSA-2007-0064.html The following updated files have been uploaded and are currently syncing to the mirrors: files: updates/ia64/RPMS/postgresql-7.4.16-1.RHEL4.1.ia64.rpm updates/ia64/RPMS/postgresql-contrib-7.4.16-1.RHEL4.1.ia64.rpm updates/ia64/RPMS/postgresql-devel-7.4.16-1.RHEL4.1.ia64.rpm

Hi guys, Pls I need good and working instructions on how to install phpmyadmin on centos 6.3 ? I would appreciate your kind and timely response on this. regards kunle

Hello, I have configured puppet and puppetdb (storeconfig) with postgresql and the service run and the collecting are good for example: I can make query with the next command and responds ok . [.........................] [root@master]# curl -X GET -H ''Accept: application/json'' http://127.0.0.1:8080/v2/facts --data-urlencode ''query=["=", "name",

Just wondering if it's possible to have an item with no content at all. Here's what I was hoping to do, inside a larger function that acts on a 3-D array. I want to enter, as one of the arguments to the main function, the index over which I'm going to do some action. For example, if the action were to calc a sum, I'd specify a given axis and report the sums along that axis

Hello, I''m not a developer myself, but I work for a hosting company that tries to cater to the needs of developers and basically right now I am trying to create a hosting platform that will be perfect for ruby developers. This is a linux VPS service and I create the base templates to make the system look however i want it after install. I was hoping some of you could give me

Say I have a file called exp.batch which contains 2 cols The first col contains names of R objects the user would like to use. The second col contains the file names which will be read in using read.table i.e. exp.batch may look like this..... name1 complex/filename/path1.txt name2 complex/filename/path2.txt name3 complex/filename/path3.txt name4 complex/filename/path4.txt I want to have a