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: submissions_n_submissi

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

[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 ret

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 i

[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 brot

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

Re: [ADMIN] hardware question

Here's a bit more anecdotal info on multi-processor systems- We've got one system with Tyan motherboard & 2 1.2 GHz Athlon processors, SCSI Raid, 1 GB RAM. We're running Debian Linux 2.4.17 & Postgres 7.2.1. We're happy with the performance, & both processors are being used by postgresql. We hav

Re: [ADMIN] Readline problems & postgresql-7.2.2

On Wed, Sep 25, 2002 at 07:08:34PM +0100, Garvey, Mary wrote: > Tried it with and without the final / on the directory name with the same > lack of success. It's being installed on a Sun Sparc, SunOS 5.8 and using > readline 4.1. Was readline compiled with the same compiler & settings? In partic

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 eac

[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

[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 = 3

[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/ --with-libraries=/ap

[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? B

[ADMIN] Sub SELECTS

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?

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] 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 o

[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. vis

[ADMIN] exclude a table from pg_dump

Hi all, is it possible to exclude a table from being pg_dumped?   In my case I need to backup everything except one table that is very large and I want to pg_dump it later   regards, kostis.  

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 ma