Re: [ADMIN] Postrgres data restoration problem

Jim Cochrane <[EMAIL PROTECTED]> writes: >> How old? We need to know the exact PG version number. > cat PG_VERSION > 7.2 That's not exact, it only tells the major release number. "postmaster --version" was what I was looking for. > However the server failed to start up, giving the following err

Re: [ADMIN] Postrgres data restoration problem

Thanks, V Kashyap, for your help. > Dear Jim Cochrane, > > >I'm looking for help restoring old postgres databases on a linux system > >after a reinstall of Redhat (including posgresql). It's the same version > >of redhat and of postgres I was using before the resinstall, but I've not > >been abl

Re: [ADMIN] Postrgres data restoration problem

Thanks, Tom, for the reply. > Jim Cochrane <[EMAIL PROTECTED]> writes: > > I'm looking for help restoring old postgres databases on a linux system > > after a reinstall of Redhat (including posgresql). > > How old? We need to know the exact PG version number. cat PG_VERSION 7.2 (Both the old a

[ADMIN] question

i have an assembley project and i need someone to help in solving the problem plaese __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ ---(end of broadcast)--- TIP 4: Don't

Re: [ADMIN] insert & update query

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > In postgresql any mechanism for store insert & update queries of a > particular database. > so that after sometime i can use those queries. > plz help me. See the "log_statement" of the postgresql.conf file: http://www.postgresql.org/docs/cur

Re: [ADMIN] find table name

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > In postgresql all databases are stored in /data/base directory in > numbers form and all the related tables with that database are stored in > that directory again in numbers form. > so there is any command or query to see the original table nam

Re: [ADMIN] Trigger to call an external program

Thanks for this Peter. I got it working by putting in the changes suggested by Stephan and adding errno.h However, I can't get any triggers to work. I'm new to postgresql, and to triggers, so it's got to be something I'm doing wrong. The test.sql script only half works. The behaviour is the

[ADMIN] Auto commit Off how will it effect us ?

Dear all , Permit me to gain some of your most valuable knowledge ... Our intrAnet server has the following spec 1. RH 9.0 2. Postgresql 7.3.4 3. PHP 4.3.3 4. GCC 3.2.2 Till date my front end language (PHP) use to simply pass the data to postgresql in case of insert and update we were

Re: [ADMIN] Error compiling PostgreSQL 7.4 for Fedora Core 1

Jonathan Gardner <[EMAIL PROTECTED]> writes: > gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes > - -Wmissing-declarations -I. -I../../../src/include -D_GNU_SOURCE -c -o > bootstrap.o bootstrap.c > bootstrap.c:118: error: `F_REGCLASSIN' undeclared here (not in a function) Hmmm ... this

[ADMIN] Error compiling PostgreSQL 7.4 for Fedora Core 1

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am trying to compile PostgreSQL 7.4 for Fedora Core 1. I used these parameters to configure: $ ./configure --prefix=/usr/local/postgresql-7.4 While running make, it returns the errors below. Any ideas? make -C bootstrap all make[3]: Entering dir