Re: [GENERAL] Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One

2015-12-26 Thread Sébastien Boutté
ata. Good night Sébastien Boutté On Sat, Dec 26, 2015 at 10:34 PM, Sébastien Boutté < sebastien.bou...@gmail.com> wrote: > Honestly, not enough information to make a determination. So: > > 1) Is the order you show above the actual order you did the restores? > No, i have m

Fwd: [GENERAL] Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One

2015-12-26 Thread Sébastien Boutté
Honestly, not enough information to make a determination. So: 1) Is the order you show above the actual order you did the restores? No, i have made multiples tests but it's always the same order of nature. 2) Are the above timings from one run for each setup or multiple runs? Multiple runs. 3) J

[GENERAL] Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One

2015-12-26 Thread Sébastien Boutté
Hi, For my project, to be able to easily manage postgres instance and version, i want to install it in user's directory and launch by user also. For my tests, I've got some issues with pg_restore on three differents installations. First One : Ubuntu 15.10 Default Package Second One : Enterprise

Re: [GENERAL] pg_dump without blobs

2007-07-20 Thread Sébastien Boutté
= $fh->filename; syswrite $fh,$data; close $fh; return $fname; $$ LANGUAGE plperlu; update my_table set new_field = lo_import(save_bytea_on_system(old_field)); I think that postgres team should add a method for doing these conversion much simplier. Sebastien On 7/15/07, Sébast

Re: [GENERAL] pg_dump without blobs

2007-07-16 Thread Sébastien Boutté
I use version 8.2.4 since last week end in my production database. I don't want to do a per table dump (I have more than 300 tables). It's not maintainable as the schema evolves regulary. On 7/16/07, Francisco Reyes <[EMAIL PROTECTED]> wrote: Sébastien Boutté writes: >

Re: [GENERAL] pg_dump without blobs

2007-07-16 Thread Sébastien Boutté
database to transform my bytea field into lo (oid) field. I would to do something similar like this : update table set new_field = oldfield but i have problem with cast from bytea to oid. Is there an efficient way of doing this update ? Thank you, Sébastien Boutté On 7/16/07, Joshua D. Drake

[GENERAL] pg_dump without blobs

2007-07-15 Thread Sébastien Boutté
Hi, I have a postgressql database with a table containing a bytea field. I would like to dump without this particulary field in order to improve dump and restore time. I try with options : -n public (without -b) but it's always the same, the dump is huge. How can i do that ? Do i have to convert