1
vote
1answer
28 views

PostgreSQL failed to start, pg_log shows nothing, what to do?

I've just setup PostgreSQL (9.3) as a replication to another server. When I started it with service postgresql-9.3 start, it reported [FAILED] without any further explanation. I don't see any thing ...
0
votes
0answers
18 views

Remove pgdg-centos92-9.2-6.noarch.rpm or enable for install PostgreSQL in CentOS 6.5

I'm trying to install PostgreSQL 9.2.6 in CentOS 6.5 and I doing as follow: Install PostgreSQL 9.2 repository rpm -Uvh ...
0
votes
1answer
45 views

Postfix with Pgsql support

I'm trying to find an alternative repo with postfix that has pgsql support on Cenots 6. I previously used CentAlt but since that seems to be dead now i'm trying to find an alternative. I would ...
0
votes
0answers
76 views

Database connection to postgresql refused for flask app under mod_wsgi when started by systemd

I'm having a weird problem where a flask application I am trying to run (https://github.com/pyfarm/pyfarm-master) under mod_wsgi under Apache under CentOS 7 cannot connect to a local postgresql server ...
0
votes
1answer
319 views

Cannot set postgres user password

Trying to install PostgreSQL with Ruby on Rails with Nginx on CentOS 6.5 using the following guide: ...
1
vote
3answers
118 views

Completely reset PostgreSQL to default?

Question Is there a way to completely reset a PostgreSQL installation on Linux, so it is in the same state as when I installed it? Idea I have considered rm -rf /var/lib/pgsql/* rm -rf ...
1
vote
0answers
168 views

postgresql: invalid authentication method “pam”: not supported by this build

When I try to start postgresql 9.3.1 I receive this in startup log: # cat /var/lib/pgsql/pgstartup.log LOG: could not create IPv6 socket: Address family not supported by protocol LOG: invalid ...
0
votes
1answer
172 views

PostgreSQL: WAL files on server are not deleted

Previously, the server was configured to hot_standby master. After a while he began to work alone. I changed the settings according to it, but the amount of WAL files is still growing ... How to get ...
0
votes
1answer
510 views

Can't install PG rubygem on Centos

I am attempting to run gem install pg on my Centos VPS but am getting Building native extensions. This could take a while... ERROR: Error installing pg: ERROR: Failed to build gem native ...
1
vote
2answers
553 views

Why doesn't sudo know where psql is?

The problem The CKAN installation documentation shows you how to list the installed PostgreSQL databases. The command looks like this: sudo -u postgres psql -l When I try that in my shell, I get ...
-1
votes
1answer
286 views

Unable to login in phpPgAdmin

I am trying to login to phpPgAdmin from a remote client. I've created the user root, but when I login phpPgAdmin returns an error message saying "Unable to login" When I check the log it says: ...
0
votes
1answer
122 views

TOLVEN installation: Test Database and LDAP Connections After ConfigPhase1

I am trying to install tolven, and following the manual http://wiki.tolven.org/index.php/Installation_Guide My linux system info is as follows: root@localhost:/> cat /etc/issue **CentOS release ...
0
votes
1answer
47 views

Sed issue with numbers exceeding 9

May be my problem is kinda obvious for you but I really need to get a solution. I need to generate a file.sql file from a file.csv, so I use this command : cat file.csv |sed "s/\(.*\),\(.*\)/insert ...
0
votes
2answers
244 views

Difference of postgreSQL's “trust” and “ident”?

In postgreSQL's /var/lib/pgsql/data/pg_hba.conf trust and ident can be set as method e.g. like so. # TYPE DATABASE USER CIDR-ADDRESS METHOD local all postgres ...
0
votes
1answer
275 views

Understanding postgreSQL's indent, md5, password in pg_hba.conf

If I have the following in my pg_hba.conf # TYPE DATABASE USER CIDR-ADDRESS METHOD local all all trust local all all ...
1
vote
1answer
777 views

Contrib directory in PostgreSQL 9.1

Where is the contrib directory in PostgreSQL 9.1? This source states its at /usr/share/pgsql/contrib but the directory /usr/share/pgsql does not exist. I installed PostgreSQL from the rpm, on a ...
0
votes
1answer
392 views

Compilation error installing Nominatim

I am trying to install Nominatim from its source on github. PostgreSQL 9.1 and PostGIS 2 has already been installed using yum. The system is running CentOS 6.3 with cPanel. git clone --recursive ...
1
vote
2answers
2k views

Dependency issue installing PostGIS on CentOs 6.3

I am new to linux and is trying to install PostGIS2 after successfully installing PostgreSQL 9.1. The machine is running CentOS 6.3 and has cPanel installed. Problem: When I tried installing PostGIS ...
0
votes
1answer
440 views

rpm -Uvh & yum install

I am new to linux and wants to understand the reason for using some commands. I am trying to install PostgreSQL on CentOs by following the instructions here. First we do rpm -ivh ...
2
votes
1answer
778 views

pg_hba.conf entry for host

Im getting this error with postgre in my centos vps Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "::1", user "xxx", database "xxx_xxx", SSL off in Here is my ...
2
votes
1answer
388 views

Can't connect to PSQL Database on a VM from my Mac

Trying to connect to my PSQL database on my CentOS VM from my Mac using pgAdmin3. Getting the following error: Access to database denied The server doesn't grant access to the database: the server ...
1
vote
2answers
3k views

How to verify PostgreSQL 9 has installed correctly on a CentOS server?

I'm trying to install the PG (postgres) gem on a CentoOS server, but it keeps saying Postgres is too old, even though I have upgraded it to 9.1.3 (as per the instructions here ...
0
votes
1answer
152 views

ERROR: function make_standard_name(unknown) does not exist while installing OSM-nominatim API

I am installing nominatim on my own server using the guidence of http://wiki.openstreetmap.org/wiki/Nominatim/Installation... But I am facing problem while adding country phrases / codes to my pgsql ...
0
votes
3answers
2k views

Cannot change PostgreSQL port

I run Postgresql 8.4 as a service on a CentOS 6.2 server. I set port = 21444 and listen_addresses = '*' in /var/lib/pgsql/data/postgresql.conf and I changed 5432 to 21444 in postmaster.opts and ...
1
vote
0answers
249 views

Apaches seems to not be shutting down Established TCP connections

I have a needle in a haystack type problem I'm trying to track down. Have not been able to recreate it on test servers. The symptom is TCP connections left in an ESTABLISHED state so don't seen to ...
0
votes
2answers
695 views

CentOS Postgres, Backup/Restore

We recently inherited a company and their CentOS server with a Postgres running their CSR db. They have a backup system in place which we know nothing about. It creates backups of the Postgres DB in ...
14
votes
3answers
14k views

How to install libpq-dev on Centos 5.5

In order to develop one web application based on postgresql, i need to install libpq on my centos. I can install it by "apt-get install libpq-dev" on ubuntu, but i can not install it on centos by ...
2
votes
2answers
520 views

SELinux prevents Apache from writing to pgbouncer's Unix domain socket

I'm using freshly installed CentOS 5.7 Linux 64 bit with PGDG packages: # rpm -qa|grep -i PG postgresql-libs-8.4.8-2PGDG.rhel5 pgdg-centos-8.4-2 postgresql-8.4.8-2PGDG.rhel5 pgbouncer-1.3.4-1.rhel5 ...
0
votes
1answer
445 views

PostgreSQL 9.0 and PHP on Amazon EC2

How can I enable PostgreSQL 9.0 support in PHP on my Amazon EC2 instance? I'm running the free 32 bit Linux Micro instance. I've installed PostgreSQL 9.0 by following these instructions ...
0
votes
1answer
549 views

why postgresql doesn't initdb at startup?

I observed a significant change in /etc/init.d/postgresql is changed in new version (postgresql-8.4.7) I was using postgresql-8.1.23 and /etc/init.d/postgresql start would do initdb if cluster doesn't ...
0
votes
1answer
3k views

CentOS6 and PostgreSQL-YUM, (Error: Cannot retrieve repository metadata (repomd.xml) for repository: pgdg90. Please verify its path and try again)

I'm using CentOS 6. I need to configure my YUM to have access to the PostgreSQL repository, but I'm getting an error. I've followed this guide: ...
1
vote
1answer
6k views

CentOS yum remove postgres is not working

I am trying to remove postgres from my CentOS server completely so I could start from the beginning, I did some seriously demented stuff!!!! one of them is deleting "/etc/init.d/postgres" But then I ...
0
votes
1answer
528 views

How to install Python and PostgreSQL on CentOS

I have a dedicated server running centOS. I want to install python 2.6 and postgreSQL on it so python users can host their web apps on my server. (Apache) Can anyone give me a detailed tutorial for ...
0
votes
1answer
80 views

problem while intalling postgres in linux(centOS)

I want to install postgresql in remote server (centOS). I am using python code(that supports linux command) in client side. And I am using rpm and yum in order to install the postgresql. My code is ...
0
votes
1answer
961 views

Problems with iptables and the access to Postgresql

I am trying to configure my PostgreSQL server to have remote access, but it was impossible to make, and when I try to allow the access on Iptables result that I can't restart the iptables. Look the ...
2
votes
1answer
769 views

Too much memory being swapped out, while cache uses it all on Centos 5.4

I've set swappiness on my DB server to zero, but during a large sort operation the swap space used grew even as the cache was still using a lot of memory, and then cache grew but swap was left alone. ...
0
votes
2answers
3k views

Roundcube can't connect to PostgreSQL database

I'm trying to install Roundcube on a CentOS 5.5 server, with a PostgreSQL 8.1.22 database. The first page of the installer script, that checks for the presence of php libraries and such, gives me ...
0
votes
1answer
379 views

ODBC error state S1092: postgresql through ODBC

While performing an upgrade, our in-house software started to report the following strange error. It is a C++ application talking to a remote postgresql database, defined through ODBC: ODBC error ...
2
votes
2answers
2k views

PostgreSQL update problems with uuid

I am trying to run yum update on my CentOS 5.2 box and keep getting this message: Missing Dependency: libossp-uuid.so.15 is needed by package postgresql-contrib I ran yum update postgresql ...
5
votes
2answers
20k views

Configuring the pg_hba.conf file to allow access from other servers to the database

I have a postgres database on one server and I need access it from another server. I need to edit the pg_hba.conf file, but have now idea what are the steps to edit this file. Server Centos I need ...
0
votes
4answers
2k views

How does SELinux affect the /home directory?

I'm migrating a CentOS 5.3 system from MySQL to PostgreSQL. The way our machine is set up is that the biggest disk partition is mounted to /home. This is out of my control and is managed by the ...