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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

On Nov-11 2003, Tue, 11:38 -0800
Theodore Petrosky <tedpet5 (AT) yahoo (DOT) com> wrote:

The data went into the $(whoami) database per default.

--
Tomas Szepe <szepe (AT) pinerecords (DOT) com>

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

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 (AT) pinerecords (DOT) com> wrote:

__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Theodore Petrosky wrote:

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html