I'm trying to install PostgreSQL and the PostgreSQL libs on RHEL5
using rpms. I'm getting dependency problems:
># rpm --test -ivh postgresql-8.3.1-1PGDG.rhel4.x86_64.rpm
>postgresql-libs-8.3.1-1PGDG.rhel4.x86_64.rpm
warning: postgresql-8.3.1-1PGDG.rhel4.x86_64.rpm: Header V3 DSA
signature
On Sat, Jan 31, 2009 at 12:23 AM, Michael Monnerie
wrote:
> On Freitag 30 Januar 2009 Tom Lane wrote:
>> The -Fc (and -Ft) formats are only designed to hold the contents of a
>> single database; and pg_restore only knows how to restore into a
>> single database.
>>
>> If you feel like fixing that,
I've browsed my history of the list, and the Internet for information
regarding giving the unix 'postgres' user a shell of /bin/false, so
that it cannot be logged into directly. It seems from my research that
if I set the user's shell to /bin/false it will not prevent the
running of postgres itself
I'm looking at tuning a PostgreSQL installation and I'm finding the
documentation confusing. (I'll also add that tuning in general is a
mystery to me!)
What are the main 'knobs' that can be used to tune PostgreSQL? If
someone can tell me that I can concentrate on learning about those
those initial
I think that you misunderstand the basics of this list. There is not a
bunch of people designated and waiting to answer your questions. It is
a self-help list. People come here to ask questions and *hope* that
someone, somewhere has an answer. Some people come here to help out by
answering peoples'
e to 9.1
> from 8.4 and deactivate the older 32 bit machines.
>
> Is that better?
>
> I am willing to hire an expert who can advise us on performance and other
> postgres fine tuning as we use this for mission critical operations.
>
> Thanks in advance.
>
> -John Coryat
&
Sorry, I forgot to mail to the list.
-- Forwarded message --
From: Aaron Bono
Date: Sun, Nov 18, 2012 at 3:24 AM
Subject: Fwd: [ADMIN] Postgre Eating Up Too Much RAM
To: Postgres
I replied to this a few days ago but forgot to include the group. It
appears that increasing our s
On Sun, Dec 9, 2012 at 7:01 AM, T.T Le wrote:
> Hello,
>
> We are running PostgresPlus 8.4AS on a linux system. I don't need to edit
> the config files or to restart the clusters (the DBA will do that for us). I
> only need access to help troubleshoot performance issues with the databases.
> My qu
If pgstartup.log is empty that points at an issue with the configuration
file. From memory, when you do an initdb it recreates the configuration
files in the /var/lib/pg... directory. I would look at the main control
file and the pg_hba.conf and try to start the database passing it the name
of the
