Re: [ADMIN] Help me!

On Apr 16, Dieudonne Nanga wrote: > How do i insert a file in the database? You mean large objects? If yes, try # select lo_import(''); this will return a OID. and to access the same, try # select lo_export(, ''); > > ---(end of broadcast)---

Re: [ADMIN] Postgresql on win2000

On Tue, 16 Apr 2002, Benjamin Lara wrote: > Hello,I want help to compile Postgresql to win2000 > Can you help me? > Please send me a e-mail > Thank you fot your help!! Look into cygwin. They have a pre-compiled package. I don't think it makes sense to compile it on your own when there is one alr

Re: [ADMIN] Help me!

Hello there! psql# \copy "table_name" from /path/from/file/to_copy Regards Sonny On Tue, 16 Apr 2002, Dieudonne Nanga wrote: > How do i insert a file in the database? > > ---(end of broadcast)--- > TIP 3: if posting/reading through Usenet,

[ADMIN] Help me!

How do i insert a file in the database? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [ADMIN] Databases in memory (-->flashdrive problem)

"Nigel J. Andrews" <[EMAIL PROTECTED]> writes: >> Sure: keep the database on a RAM-drive (this will mean an initdb and >> data load on each bootup, hope you can stand that) and use pg_dump to >> a text file on flashdrive as your backup mechanism. Use a cron task >> to run pg_dump at whatever freq

Re: [ADMIN] psql command line history not working

Em 15 Apr 2002, Peter Eisentraut escreveu: >> I am trying to get command line history and editing to work with psql, as >> life is a pain without it. > >Check that you have the readline header files installed (and if configure >finds them; readline.h, history.h or similar). Look for RPMs >r

Re: [ADMIN] Vacuum blocking...

Jean-Arthur Silve <[EMAIL PROTECTED]> writes: > Now, vacuum "blocks" on one table (apparently "comptes" table) , without HD > activity, no error message Curious. Do you want to get in there with a debugger and see where it's looping? > PS : I use 7.0 version Hmm ... are you on 7.0.3? The

[ADMIN] Postgresql on win2000

Hello,I want help to compile Postgresql to win2000Can you help me? Please send me a e-mailThank you fot your help!!

[ADMIN] Lost Data. Need to get back with pg_control - pg_xlog

Hi, I am running Postgresql 7.1.3. The machine that the database server is on got rebooted accidentally. After I started the server, the data in tables are gone. I heard some thing about possibly get the data back with pg_xlog by using pg_control. Can anyone provides the instructions of how do

Re: [ADMIN] Databases in memory (-->flashdrive problem)

On Mon, 15 Apr 2002, Tom Lane wrote: > "Christian Gerdes" <[EMAIL PROTECTED]> writes: > > Is there an opportunity to configure postgre to keep databases in Memory? > > I need to store a lot of data (many little entries) on IDE- flashdrive. > > But flashdrives have a little problem with write-cy

[ADMIN] new problems

hi, i made some step from the previous e-mail. here are the new problems: I disinstalled the rpm of pgsql 7.0 and i tried to install the rpm of 7.2 version: 1) the rpm managers tell me that are missing some lib - libcrypto.so.2 - libreadline.so.4 - libssl.so.2 i tried to install anyw

[ADMIN] Vacuum blocking...

Hello ! I used to run vacuum verbose analyze (vacuumdb -v -a -z) every days. Everything was ok for months until yesterday ! Usually, this command takes about 1 mn. Now, vacuum "blocks" on one table (apparently "comptes" table) , without HD activity, no error message avr 15 10:31:27 uranus