0
votes
0answers
84 views

Postgres using only 500 MB of RAM of the available 4 GB

We recently moved to running postgres server on it's own VM and tracked the memory usage of the VM. Here is what I found: That the postgres is only using 500 MB of the available memory on the VM. ...
5
votes
1answer
327 views

Can I enable both peer and md5 authentication for the same PostgreSQL local user in pg_hba.conf?

I would like to let a PostgreSQL (super)user be authenticated with either the "peer" or "md5" authentication methods, preferably using local Unix domain sockets in both cases. The problem is that the ...
0
votes
1answer
372 views

postgresql unable to start

postgresql log file: * Starting PostgreSQL 9.1 database server * The PostgreSQL server failed to start. Please check the log output: 2012-02-24 04:26:07 GMT ...
2
votes
1answer
128 views

how to optimize postgresql81 for a hug query but not a complicated one?

i have a query which execution takes 15s on the server. the server is bi-xeon 5130 (2GHz) with 2GB of RAM and 160GB of scsi hardrive in RAID. Database is PostgreSQL 8.1 on Debian 4 etch. This query ...
0
votes
2answers
383 views

Joomla 1.5 with Postgresql 8.4

can anybody guide me to get to work Joomla 1.5.X with a postgres 8.4 database ? Thanks
2
votes
1answer
6k views

PostgreSQL pg_hba.conf problem adding a host?

I'm having a problem with configuring my postgresql server. I've installed PostgreSQL 9.0.2 on slackware 13.1x64 and it runs fine but I can't add a IP that could connect to PostgreSQL remotely. The ...
0
votes
2answers
444 views

how to prevent log output from PostgreSQL stored procedure?

I am running a number of PostgreSQL scripts that used to produce excessive log output. I managed to reduce most of the output to an acceptable amount by passing --quiet as parameter to the psql ...
0
votes
1answer
239 views

PostgreSQL 9.0.1 Multiple Clusters and Shared Buffers Settings in Windows Server 2008 R2

According to the PostgreSQL documentation, "The useful range for shared_buffers on Windows systems is generally from 64MB to 512MB.". I'm wondering how this might alter when running multiple ...
1
vote
1answer
1k views

unable to connect to PostgreSQL 8.4 on Ubuntu 10.04 server

I installed postgresql 8.4.x on Ubuntu server 10.04 on x386 box. I also did the following steps edited /etc/postgresql/8.4/main/postgresql.conf and added the following lines listen_addresses = ‘*’ ...
0
votes
3answers
4k views

Location of postgresql.conf and pg_hba.conf on an Ubuntu server

Where are the files postgresql.conf and pg_hba.conf on a Linux server running PostgreSQL 8.4 installed from Ubuntu repos?
2
votes
5answers
2k views

Reloading PostgreSQL after configuration changes

I've made some changes to pg_hba.conf and I want them to take affect. I've found several places where people say that I can tell PostgreSQL to reload, but there are several different techniques ...