Re: [ADMIN] hardware question

Hello *, thanks a lot for the quick responses. It looks like I have to answer a few questions. - I am talking about P4 Xeon - Getting away from SUN is the attemp to reduce costs. I think I don't have to mention the amount of money that has to be spent on service contracts (even with older

[ADMIN] How do i use PostgreSQL for Windows in my product ?

Hai All, I would like to use PostgreSQL for Windows in my product. What should i do ? Becoz 7.2.1 says that it is only for developement. Poorna Missed your favourite TV serial last night? Try the new, Yahoo! TV.

[ADMIN] Problem with bulk inserts

I am running into a strange problem with postgresql when I attempt to insert 1200 rows per second into a database. The problem is not due to the machine (Dual Xeon 2.2ghz, 2GB, RAID 1/0, running FreeBSD 4.6.2-REL). Postgres consumes approximately 3 to 4% CPU time. Very little disk activity

Re: [ADMIN] [DBmirror Issue] recordchange() dies in packageData unless

On Mon, 23 Sep 2002, Rajesh Kumar Mallah. wrote: Hi Is anyone using dbmirror in production? We've been using it in production for sometime now and haven't been having any problems with it. I Intend to replicate a set of tables between local and remote servers. and plan to use

[ADMIN] Sub SELECTS

I have a select query with 2 sub selects. When I run that queryCPU usage goes to 98% for postgres. Doessub selects eat more resources and slower the queries? Is there any alternatives to sub selects?

[ADMIN] restore db from files

I am fairly new to Postgres. And seems to have made a big mistake trying to backup the DB. I copied all the files in the database folder. Now that the DB crashed, i reinstalled Postgres and copied the files back but postgres can't find them. Can anybody help to restore my Db from those files?

[ADMIN] Readline problems postgresql-7.2.2

Hello, I've been trying to get postgres to install with readline, but keep getting: checking for readline... (cached) no With previous versions the following seemed to do the trick: ./configure --prefix=/apps/postgres/pgsql --with-includes=/apps/postgres/readline/include/

[ADMIN]

Hi! I have compiled PostgreSQL in many versions off linux and all run ok. Now, i nedd to compile it in SCO but the configure program abort. Can you help me please? Thank you! Regards, Sergio OS version (from 'uname') - SCO Open Server 5.0.4 System = SCO_SV Release =

[ADMIN] PostgreSQL on SCO

Hi! I nedd to compile it in SCO but the configure program abort. Can you help me please? Regards, Sergio OS version (from 'uname') - SCO Open Server 5.0.4 System = SCO_SV Release = 3.2v5.0.4 KernelID = 97/05/07 Machine = Pentium Pro gmake version - 3.78.1

Re: [ADMIN] exclude a table from pg_dump

On Sun, Sep 22, 2002 at 02:27:52PM +0300, Kostis Mentzelos wrote: Hi all, is it possible to exclude a table from being pg_dumped? Not really. If you knew there were no connections (and therefore no-one changing data) you could do it in a shell script, passing the -t option to pg_dump for each

Re: [ADMIN] Sub SELECTS

On Wed, 25 Sep 2002, Waruna Geekiyanage wrote: I have a select query with 2 sub selects. When I run that query CPU usage goes to 98% for postgres. Does sub selects eat more resources and slower the queries? Is there any alternatives to sub selects? It depends on what you're doing. The

[ADMIN] old db on a new system

ok, so i've got a pretty bad problem. my system go borked last week, and i had to back everything up and reinstall. i was running postgresql 7.0.* on openbsd2.8. i switched to gentoo 1.2, and it emerged postgresql 7.2.2. now i've got some old databases on a new system that can't use them. my

Re: [ADMIN] old db on a new system

after some playing, we finally got postgres 7.0.3 running, now on pg_dump, i get an error: ./bin/pg_dumpall dumped ERROR: Cannot insert a duplicate key into unique index pg_type_typname_index ERROR: Relation 'tmp_pg_shadow' does not exist ERROR: Relation 'tmp_pg_shadow' does not exist if

[ADMIN] pg_dumpall fails

begin flood bleh. i can't tell if i'm getting somewhere, or running around in circles. i don't know what my brother has been doing on the other end, but pg_dumpall now returns this: SELECT nextval ('art_links_id_seq'); dumpSequence(submissions_submission_id_seq): different sequence name

Re: [ADMIN] old db on a new system

Willy Wonka [EMAIL PROTECTED] writes: after some playing, we finally got postgres 7.0.3 running, now on pg_dump, i get an error: pg_dump immedia immediadb Connection to database 'immedia' failed. FATAL 1: Database 'immedia', OID 18784, has disappeared from pg_database Try vacuum

Re: [ADMIN] pg_dumpall fails

Willy Wonka [EMAIL PROTECTED] writes: i don't know what my brother has been doing on the other end, but pg_dumpall now returns this: SELECT nextval ('art_links_id_seq'); dumpSequence(submissions_submission_id_seq): different sequence name returned by SELECT: