From: | Theodore Petrosky <tedpet5(at)yahoo(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | RC1 question of reloading data |
Date: | 2003-11-11 19:38:24 |
Message-ID: | 20031111193824.28906.qmail@web41008.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I just downloaded and installed RC1 (7.4) on OSX 10.3.
Everything went smoothly for the config. make and
install.
while reloading the data (from pg_dump in 7.3) I
inadvertently screwed up. Or maybe not...
my dump file was as1.out so I...
psql < as1.out
I knew it was wrong the moment after I hit the return
as I did not specify the database (i did create it
with createdb). I did not get any error message. I
went looking to see if the data was pushed somewhere
bad like template1. But couldn't find it.
I did load my data correctly but, where did the first
set go? Did it just disappear into the ether?
Ted Petrosky
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
From | Date | Subject | |
---|---|---|---|
Next Message | lucas sultanum | 2003-11-11 22:51:27 | Locking Mechanism |
Previous Message | SHADOWPLAY - Dave Adams | 2003-11-11 06:15:38 | Selecting from a VIEW is NOT optimized like a similar SELECT statement |