similar to: PostgreSQL/SELinux Error - relation "pg_catalog.pg_user" does not exist

Displaying 20 results from an estimated 6000 matches similar to: "PostgreSQL/SELinux Error - relation "pg_catalog.pg_user" does not exist"

2006 Feb 16
3
Postgresql 8.1.x on CentOS 3.6
Hello everyone, Does anyone know if there are any Postgresql 8.1.3 RPMs for CentOS 3.6? I've looked at the Postgresql website but I couldn't find anything under RHEL3/CentOS3. I've tried installing the RHEL4 RPMs which seem to work. Unfortunately, I'm getting errors whenever I try to compile PHP5 from source. Thanks and Best Regards, Matt -- Stand before it and there is no
2005 Apr 28
1
relation "pg_user" does not exist error when running pg_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 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
2005 May 24
2
PostgreSQL/SELinux Error - relation "pg_catalog.pg_u ser" does not exist
> > The best thing to do is add this to /etc/selinux/config > > SELINUX=disabled > > And then get on with the real jobs.... > Listening to all the pros and cons of SELinux. I'd like to improve the security of our regional web server using SELinux. We have a main regional web site and several virtual domains, kept up by private users, all on the same server. Some of
2007 Oct 30
4
Postgresql and shell script
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
2007 Mar 25
4
Cannot execute /usr/bin/fetchmail
Hello everyone, I'm setting up a fetchmail command to run every five minutes so I can get email from another POP3 account. The fetchmail package was installed via yum. I can execute the command manually on the command line. But I'm having trouble when it's run from cron. I have noticed that commands run via cron and execute via /bin/sh, so I tried to run the fetchmail command
2008 Jun 27
6
African IP addresses list
Hi all, I am trying to block all IP addresses from Africa due to a high rate of fraudulent orders coming from them. I have some found some websites that can generate a range of IP addresses. However, you would have to enter the ranges by country. I can use those perhaps but that would mean I would have to get the ranges for each country one by one. Has anyone here a list of addresses from
2009 Sep 24
3
Using yum with CentOS-2 mirrors
Hi all, I was having yum errors while updating our CentOS-2 box. Further reading lead me to a readme file on the mirrors (http://mirror.centos.org/centos-2/readme.txt) and it gave me the new URL to use for CentOS-2 mirrors. I have edited /etc/yum.conf with the new URLs but I'm still having issues with yum giving me "ValueError: unpack list of wrong size" errors. Has anyone been
2010 Aug 06
3
yum-fastestmirror inconsistent exclude behavior
Hi guys, I'm trying to figure out something wherein excluded repositories for the yum-fastestmirror plugin are still being used by the system. To illustrate: [root at sales ~]# cat /etc/yum/pluginconf.d/fastestmirror.conf [main] enabled=1 verbose=0 socket_timeout=3 hostfilepath=/var/cache/yum/timedhosts.txt maxhostfileage=10 maxthreads=15 #exclude=.gov, facebook exclude=maulvi, .gov.ph, .vn
2007 Aug 24
3
"Site down for maintenance" - How is this accomplished?
Hello everyone, Although we use CentOS primarily on our servers, this query is actually more of a general networking question than something specific to CentOS. In the next week or so, we shall be migrating our in-house servers to a data center. While we're doing that, we'd like to show a "Site down for maintenance" message while the servers that hosts our websites (we have
2007 Aug 27
2
Getting info on hardware RAID
Hello everyone, I'm doing an audit of all our servers here (there aren't that many maybe around 5-10) and one of the things I'm doing is taking note of each server's hardware specs (processor, memory, etc). I can't seem to figure out how to get the information for the hard drives. The drives are in a hardware RAID5 array and are all SCSI types. I would like to get each
2008 Mar 04
2
Overwrite target of ln
Hi all, Sorry if this seems too basic. But is there a way to overwrite the target of a symbolic link without first deleting the symlink itself? For example, if I have this: public_html -> releases/b2b-20080228 ... and there's a new update, I can then just do the following: $ ln releases/site-latest public_html I tried using the -f option but it doesn't seem to work as expected.
2008 Mar 28
2
Samba Administration Tool recommendations
Hi All, I have a project which is to build a customized Linux distribution with a focus on deploying a Samba as Primary Domain Controller. It's pretty much like Trixbox but instead of Asterisk and VOIP, will be focused on Samba. Right now, I am looking for a solution for an administrator to easily manage the service. Of particular importance would be to easily add workstations and set up
2005 Apr 28
0
relation "pg_user" does not exist error when runningpg_dump
> -----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
2007 Oct 24
1
TFTP server not working as expected when run from xinetd
Hi All, I have a Trixbox server (CentOS derivative) from which our Cisco IP phones get their config files via TFTP. I have noticed that when I run the TFTP server via "service xinetd start", I am not able to get files via TFTP. I have tested it by doing a manual transfer via a TFTP client from another machine. When I try to run the TFTP service manually by doing
2008 Aug 26
1
screen not sourcing .bashrc
Hi everyone, I use the "screen" command from time to time and what i would still have to figure out how to do is for it to be able to source .bashrc and read my user-defined configuration (aliases for example). I have already added the "source /root/.bashrc" line on /root/.screenrc but it doesn't seem to be working. Would anyone know how this should work? Thanks, Matt
2009 Aug 29
1
Run GNU screen as a normal user
Hi guys, I am currently looking for a workaround with regards to running screen as a normal user. When I try to run it, I get the following: [mbaluyos at mla torrents]$ screen Cannot open your terminal '/dev/pts/0' - please check. To get around this, I had to chmod 777 /dev/pts/0. It's an insecure hack so I'm looking for the right way of doing it. Would anyone be able to guide
2006 Apr 30
16
postgresql duplicate key violates unique constraint
I have a weird problem with creating a new record when using PostgreSQL. From inside script/console ... >> entity = Entity.new >> entity.first_name = "Foo" >> entity.last_name = "bar" >> entity.save Throws an exception due to the following SQL error: duplicate key violates unique constraint. The application was working fine before and suddenly
2007 May 11
1
postgres erros on RHEL 4
Hi All, I set up posgresql on RedHat El4. Below are rpms I installed. [root at LinuxBox etc]# rpm -qa |grep postgres postgresql-libs-7.4.16-1.RHEL4.1 postgresql-devel-7.4.16-1.RHEL4.1 postgresql-7.4.16-1.RHEL4.1 postgresql-python-7.4.16-1.RHEL4.1 postgresql-server-7.4.16-1.RHEL4.1 Then, I did below commands to create a user and a database. [root at box root]# su postgres bash-3.1$ createuser
2008 May 05
2
RODBC and schemas
I have found that the "schema.table" syntax used in Postgresql (and Oracle) does not work directly with RODBC. This works library(RODBC) con<-odbcConnect("mydb") d<-sqlQuery(con,"select * from meso.trees") However this does not. d<-sqlFetch(con,"meso.trees") Error in odbcTableExists(channel, sqtable) : ?meso.trees?: table not found on channel
2007 Jan 22
1
Music on Hold on IP Phones with FreePBX 2.2.0
Hello everyone, We just installed a new Trixbox 2.0 server and updated FreePBX to 2.2.0 from 2.2.0rc3. We are having some problems with regards to Music on Hold on IP phones. When we press the "Hold" button, the caller doesn't hear the MOH sound. This functionality used to work with the older Asterisk@Home installation on the same hardware and configuration. However, we don't