Thread: RC1 question of reloading data
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
On Nov-11 2003, Tue, 11:38 -0800 Theodore Petrosky <tedpet5@yahoo.com> wrote: > 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 The data went into the $(whoami) database per default. -- Tomas Szepe <szepe@pinerecords.com>
So, I was logged on as postgres. but there is no database called 'postgres' (or maybe I don't understand the internals). Keep in mind that I am only looking for understanding of the process... and I want to make sure that doing this doesn't create problems later. Ted --- Tomas Szepe <szepe@pinerecords.com> wrote: > On Nov-11 2003, Tue, 11:38 -0800 > Theodore Petrosky <tedpet5@yahoo.com> wrote: > > > 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 > > The data went into the $(whoami) database per > default. > > -- > Tomas Szepe <szepe@pinerecords.com> __________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree
Theodore Petrosky wrote: > So, I was logged on as postgres. but there is no > database called 'postgres' (or maybe I don't > understand the internals). Keep in mind that I am only > looking for understanding of the process... and I want > to make sure that doing this doesn't create problems > later. > > Ted Postgres is not a 'database', it is the account name which owns the commands and the directories with which and into which the database structure is created using "initdb". If you followed the short installation version you would have done something like this: jerry$ su root@jerry# mkdir /usr/local/pgsql/data root@jerry# chown postgres /usr/local/pgsql/data root@jerry# su - postgres -bash-2.05b$ initdb -D /usr/local/pgsql/data Then you could log in using psql and create your user name and db template, etc. -- GreyGeek