Re: [ADMIN] Installation of PostgresQL 8.1 in Redhat Linux ES 4.0

Title: Installation of PostgresQL 8.1 in Redhat Linux ES 4.0   Is it possible to install PostgresQL 8.1 in Redhat Linux ES 4.0, if it is how can I get installation steps or installation documentation for this installation.     You can get the sources for Linux Redhat from the following site o

Re: [ADMIN] Installation of PostgresQL 8.1 in Redhat Linux ES 4.0

Hi, On Thu, 2005-12-08 at 17:04 +0530, Murugan G wrote: > Is it possible to install PostgresQL 8.1 in Redhat Linux ES 4.0, if it > is how can I get installation steps or installation documentation for > this installation. We (PostgreSQL RPM Building Project) have written a document about installi

Re: [ADMIN] REINDEX Issue - DB Management

"Rodrigo Hjort" <[EMAIL PROTECTED]> wrote >- How often do you REINDEX your databases? > - What do you verify on the database to know that it is time to reindex? > There is no unique answer to the first one. You can binary search your optimal reindex rate. Suppose the workload is steady, then you

Re: [ADMIN] using pgdb and python

> I am using pgdb. I know psycpg is also a DBI compliant interface for > postgresql. If there is a recommendation as to which one is better, > I'd like to hear it. (better for me now means that it has better > documentation, sample code, etc.) I know nothing of pgdb but Command Prompt uses psycop

[ADMIN] using pgdb and python

I am using python to collect data and insert it into postgresql. I am hoping there will be someone on this list that has used python for this becuase all the books and documentation on the subject seem sparse. I am using pgdb. I know psycpg is also a DBI compliant interface for postgresql. If ther

Re: [ADMIN] Installation of PostgresQL 8.1 in Redhat Linux ES 4.0

I don't have any RHES 4.0 boxen, but I do have a CentOS 4.1 box. You can get RPMS for the new version of PostgreSQL, you will probably want to install a compat rpm that has the libraries that the other software on the system requires. I forget where I downloaded mine from, but someone on one

[ADMIN] pg_control

    Hello to everybody. I just have a newbie question.when i moved my data directory and gave the new path while starting. the following exception occurs. could not open control file "": Permission denied. iam using windows xp and postgres-8.0.3. but the file exists there with same user permiss

Re: [ADMIN] the time for [EMAIL PROTECTED] has come?

gbarosio sighs! cheers, g.-On 12/8/05, Tom Lane <[EMAIL PROTECTED]> wrote: Guido Barosio <[EMAIL PROTECTED]> writes:>The point is that I am wondering about the need of a new mailing>list,There's already pgsql-novice. regards, tom lane-- "Adopting the position that y

[ADMIN] REINDEX Issue - DB Management

- How often do you REINDEX your databases? - What do you verify on the database to know that it is time to reindex? I currently have a PostgreSQL 7.4.7 server with a 500 MB database (about 200 tables). I made a Shell script that calls /contrib/reindexdb. Then I put it on crontab, the way it is exe

Re: [ADMIN] the time for [EMAIL PROTECTED] has come?

Guido Barosio <[EMAIL PROTECTED]> writes: >The point is that I am wondering about the need of a new mailing >list, There's already pgsql-novice. regards, tom lane ---(end of broadcast)--- TIP 1: if posting/reading th

Re: [ADMIN] the time for [EMAIL PROTECTED] has come?

Guido Barosio wrote: All, (boring mail ahead) Writing here to get in contact with major people. Recently, with the new Windows port, and a great massive reception of the new release, I've noticed that too many threads are being sent to pgsql-admin regarding: "How do I install" "How do I b

[ADMIN] the time for [EMAIL PROTECTED] has come?

All, (boring mail ahead)    Writing here to get in contact with major people. Recently, with the new Windows port, and a great massive reception of the new release, I've noticed that too many threads are being sent to pgsql-admin regarding: "How do I install" "How do I backup" "What is initdb" e

Re: [ADMIN] Backing up views, functions

Benjamin Arai wrote: I have a database of several million records and we are currently developing pl functions and views. How do you dump only the code for views and functions? Benjamin Also, one way of recreating views: select 'drop view '||viewname||'; CREATE OR REPLACE view '||viewname|

Re: [ADMIN] Backing up views, functions

Benjamin Arai wrote: I have a database of several million records and we are currently developing pl functions and views. How do you dump only the code for views and functions? Benjamin This has come up before, if you search the archives, you'll find various ways of accomplishing this. Her

[ADMIN] Installation of PostgresQL 8.1 in Redhat Linux ES 4.0

Title: Installation of PostgresQL 8.1 in Redhat Linux ES 4.0 Hello, Is it possible to install PostgresQL 8.1 in Redhat Linux ES 4.0, if it is how can I get installation steps or installation documentation for this installation. Thanks and regards, G.Murugan, Sr. Software Engin

[ADMIN] pg_dumpall problems with Postgresql 7.4

Hi, First, i didn't find a resolution to my problem in the archives ... I use Postgresql 7.4 and I have a big problem dumping databases : This is the view from the command line (postmaster launched on port 5228 to isolate it from other requests) : pluton:/etc/init.d # ./postgres start Starti

Re: [ADMIN] Unable to restore compressed file.

Hi,    I wasn't sure, but checking the documentation I've found that both pg_dump and pg_restore don't allow the "-u" switch, but yes "-U Check (for pgsql 8):    http://www.postgresql.org/docs/8.0/interactive/app-pgdump.html    http://www.postgresql.org/docs/8.0/interactive/app-pgrestore.htmlBest

Re: [ADMIN]

Hi, I had similar situation with a RedHat box, I just compiled postgres 8.0.4 from sources, its really not that difficult. That way I did not have to take the 7.4 offline while I was doing the upgrade, of course I had to change the data dir for 8.0.4. regards, iges. On Tuesday, 6. December 2005