[ADMIN] Postgresql beta4 rpms

2004-11-02 Thread Werner Bohl
Hi! Where may I downloads Postgresql beta4 rpms or srpms for Fedora Core 2? TIA, -- Werner Bohl <[EMAIL PROTECTED]> Infutor de Costa Rica S.A. ---(end of broadcast)--- TIP 8: explain analyze is your friend

[ADMIN] Binary Cursors and On-The-Wire

2004-11-02 Thread Naomi Walker
7.4 changed the external representation in which BINARY CURSOR results > > are delivered. Before 7.4 you got the (very machine- and even version- > > dependent) server internal representation; now you get an on-the-wire > > representation that we hope to keep stable. Tom or group, can you please

Re: [ADMIN] initlocation -- command not found -- HELP NEEDED

2004-11-02 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 1 Nov 2004, azariah jason wrote: I am worknig as a Sys/ DB Admin in a reputed Company. In My postgreSQl 7.4 i am not able to run "initlocation" Command. It gives Command not found error. To rectify this what should i do ? Install postgresql-

Re: [ADMIN] initlocation -- command not found -- HELP NEEDED

2004-11-02 Thread Michael Fuhr
On Tue, Nov 02, 2004 at 08:08:02AM +, azariah jason wrote: > > I am using RH EL 3.0 with postgreSQL 7.4.i . > > In this i am not able to issue initlocation command . i searched > the commaned but not found.How do i do for invoke this command? as > well what addtional pakegs to be installed?

Re: [ADMIN] postgres gets slower after some while

2004-11-02 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, Edgars <[EMAIL PROTECTED]> writes: > Jaime, > thanks for the response! > yes, i have tried this VACUMM, it gives some effect but only for some > time (2hours or so). Maybe you know why it is happening so? PostgreSQL can't run for long without a proper VACUUM poli

[ADMIN] pg_dump question

2004-11-02 Thread Andrei Bintintan
Hi to all,   If I create a table with create table and after that I modify the table(add some columns) in the dump the table is saved in the same way, I mean, in the dump first the table is created and after that the column is added.   Is there a possibility to dump the database and the ta

Re: [ADMIN] postgres gets slower after some while

2004-11-02 Thread Edgars
Jaime, thanks for the response! yes, i have tried this VACUMM, it gives some effect but only for some time (2hours or so). Maybe you know why it is happening so? Edgars Jaime Casanova wrote: --- Edgars <[EMAIL PROTECTED]> escribió: Hey, make some futher testings regarding my previous post (su