Re: [ADMIN] Backup / Restore

Dear Eduardo , What is the most recommended way to backup a PostgreSQL database? pg_dump --disable-triggers -U -a -d -b -D -Fc -Z 9 -f + A file system backup could be done but for this you will have to shutdown PostgreSQL server before filesystem backup is done And to restore it? pg_re

Re: [ADMIN] hi.

Dear Janio , checking for a BSD-compatible install... /usr/bin/ginstall -c checking whether build environment is sane... configure: error: newly created file is older than distributed files! Check your system clock "Check your system clock" check this Or your bison tarball is older than the alre

Re: [ADMIN] hi.

Dear Janio , checking for tar... /bin/tar checking for strip... strip checking whether it is possible to strip libraries... yes checking for bison... bison -y *** The installed version of Bison is too old. PostgreSQL needs *** Bison version 1.875 or later. Upgrade your Bison and make Packages Ho

Re: [ADMIN] VARCHAR -vs- CHAR: huge performance difference?

Dear C. Bensend wrote: I am parsing and storing emails, so I have a lot of character string data to worry about. In one particular table, I have 26 columns of type varchar, with widths of 24-8192 characters. This is the table that is giving me some pretty severe performance problems. For exam

Re: [ADMIN] pgsql initial superuser

Dear Pedro , Hello. this is my "first" time using pgsql, and I seem to be running to a bit of a corner here :-) I've understood how to add a superuser/database-user/user but I have no user to begin with. ~# createuser superuser Shall the new user be allowed to create databases? (y/n) y Shall th

Re: [ADMIN] ppp link activated on startup

Dear tatel, But after compile-install postgresql 7.4.1 with postgis, ppp link is activated on startup, which is very unpleasant. In postgresql.conf tcpip_socket is set to false. I'm shure this is a postgresql affair, since removing postgresql rc scripts corrects this problem. But no more postmaster

Re: [ADMIN] PostgreSQL 7.3.4 to 4.2 Regresion Fails

Just an update : I ignored the Regression test results and went forward to install PostgreSQL 7.4.2 After this I re ran there Regression test and it failed 1 test of 93 I again ran the test and all 93 test passed Now the only question I have is since initdb and all is working fiine Must I tak

[ADMIN] PostgreSQL 7.3.4 to 4.2 Regresion Fails

Dear all, I am migrating from PostgreSQL 7.3.4 to PostgreSQL 7..4.2 Steps followed are : 1. Backup 2. Get the copy >> extract >> own the extracted files by postgres (SuperUser) 3. Remove the old data directoy as old and new data directory would be same 4. Configure with ./configure \--bindir=/u

Re: [ADMIN] pg_restore data block error

Dear Anjan Dave  , Message -bash-2.05b$ pg_restore -a -d access backups/access/data.pg pg_restore: [custom archiver] could not read data block -- expected 4096, got 3608 To me this seems as a error in file format. Anyways try using the following pg_restore --disable-triggers -i -a

Re: [ADMIN] problems with regressive tests on rh8.0

Dear Andrew Kornilov , I've successfully built 7.4.1 was build without any difficulties, but fail all of regressive test Check your Disk Space specially the partition on which PostgreSQL is being build. Re run your regression test and you may get 93 passed result Do inform me if this help

Re: [ADMIN] Selects query inside function must read commited data

Dear Oliver Elphick  , If I am not wrong PostgreSQL select statements works on committed data thus the new inserted data at #3 must not be available to sai_func_b() till #5 No. All operations by a single transaction are visible inside the transaction. Therefore an encapsulat

Re: [ADMIN] Selects query inside function must read commited data

Would like to receive your kind attention and enormous knowledge on the following This tickles me I have a function So what ? sai_func_a() Which does as follows and in the same order: 1. Retrieves the latest record from the table test_sai (By latest I mean the record corresponding to max pri

[ADMIN] Selects query inside function must read commited data

Dear all , Would like to receive your kind attention and enormous knowledge on the following I have a function sai_func_a() Which does as follows and in the same order: 1. Retrieves the latest record from the table test_sai    (By latest I mean the record corresponding to max primary key of t

Re: [ADMIN] Installation Problem on windows.

Dear nilesh Ghone , I want to install PostgreSQL on my PC, (Operating System - Windows 2000 professional). I am following FAQ_mswin provieded by PostgreSQL documentation.I have installed cygwin. While installation error message occours - "cygcrypt-0.dll We need some details as follows : 1. Tel

[ADMIN] How can i start PostreSQL automatically

hi all this question probably have been asked many times, but i couldn't find the answer anywhere. i have RH 5.1 and want to start pg automatically everytime i turn my system on. how can i do that? thanx mark __ Get Your Private, Free Email