Re: [ADMIN] "DELETE FROM" protection

nd an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > > Yuji Shinozaki Computer Systems Senior Engineer [EMAIL PROTECTED] Advanced Technologies

Re: [ADMIN] [Fwd: binary tree query]

__ > //Jodi L Kanter > BioInformatics Database Administrator > University of Virginia > (434) 924-2846 > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>/ > > > > / / > > / / > > Yuji Shinozaki Computer Sys

Re: [ADMIN] constaint addition to existing schema

gt; [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>/ > > > > / / > > / / > > Yuji Shinozaki Computer Systems Senior Engineer [EMAIL PROTECTED] Advanced Technologies Group (434)924-7171 Informati

Re: [ADMIN] compare two databases

uno LEVEQUE > System Engineer > SARL NET6D > [EMAIL PROTECTED] > http://www.net6d.com > > > > ---(end of broadcast)--- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail co

[ADMIN] Dumping select tables (omitting tables)

least last)? Or can I simply concatenate all these single-table dumps and tell pg_restore to apply the indexes last? Is there a simple way to accomplish this? yuji Yuji Shinozaki Computer Systems Senior Engineer [EMAIL PROTECTED] Advanced Technol

Re: [ADMIN] pg_ctl won't start postgres, but postmaster will?!

/pg_ctl -D /pgdata -l /var/log/pgsql > start" > > it doesn't work! And I'm still confused as to why the script doesn't work. Terse answer: Do not use quotes in your exec statement. yuji Yuji Shinozaki Computer Systems Senior Engineer [EMAIL

Re: [ADMIN] copying databases w/ indexes

wrote: > Yuji Shinozaki <[EMAIL PROTECTED]> writes: > > Then the problem is that > > reindexing takes a very long time. One particular index is taking on the > > order of 12 hours to finish. > > Seems like a lot. What is the index definition exactly, and how many >

Re: [ADMIN] copying databases w/ indexes

mention inserts) slow! Now the restore only takes about 20 minutes (yay!) Thanks, yuji On Thu, 14 Aug 2003, Sam Barnett-Cormack wrote: > On Thu, 14 Aug 2003, Yuji Shinozaki wrote: > > > > > I have two questions about restoring and moving databases (in pg 7.3), to > &g

[ADMIN] copying databases w/ indexes

found is dump/restore, and again we pay the penalty of the 12-hour reindexing. Any pointers? Thanks! yuji Yuji Shinozaki Computer Systems Senior Engineer [EMAIL PROTECTED] Advanced Technologies Group (434)924-7171