Re: [HACKERS] CREATEDB Where ??
> Yes and no :-). The files were created but all postgres data files are now > idententified by numbers (oids I think), so you will not find a file or > directory anywhere in your filesystem named "mydb", or "mytable". /contrib/oid2name in 7.1.X does the mapping. > > - Original Message - > From: "Peter Moscatt" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, August 17, 2001 9:05 AM > Subject: [HACKERS] CREATEDB Where ?? > > > > I am pretty new to PostgreSQL so please bare with me :-) > > > > When issuing the CREATEDB MyDb then creating some tables with CREATE > > TABLE, I then go back and do a search for the file I have just created > > (MyDb) but can't find the physical file. > > > > Does one actually exist ?? > > > > Pete > > > > > > ---(end of broadcast)--- > > TIP 6: Have you searched our list archives? > > > > http://www.postgresql.org/search.mpl > > > ---(end of broadcast)--- > TIP 4: Don't 'kill -9' the postmaster > -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [HACKERS] CREATEDB Where ??
Yes and no :-). The files were created but all postgres data files are now idententified by numbers (oids I think), so you will not find a file or directory anywhere in your filesystem named "mydb", or "mytable". - Original Message - From: "Peter Moscatt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 17, 2001 9:05 AM Subject: [HACKERS] CREATEDB Where ?? > I am pretty new to PostgreSQL so please bare with me :-) > > When issuing the CREATEDB MyDb then creating some tables with CREATE > TABLE, I then go back and do a search for the file I have just created > (MyDb) but can't find the physical file. > > Does one actually exist ?? > > Pete > > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] CREATEDB Where ??
Peter Moscatt <[EMAIL PROTECTED]> writes: > I am pretty new to PostgreSQL so please bare with me :-) > > When issuing the CREATEDB MyDb then creating some tables with CREATE > TABLE, I then go back and do a search for the file I have just created > (MyDb) but can't find the physical file. > > Does one actually exist ?? Yes, they're named by OID (integer) in $PGDATA rather than by database name. There's a reason for this so don't complain about it. ;) -Doug -- Free Dmitry Sklyarov! http://www.freesklyarov.org/ We will return to our regularly scheduled signature shortly. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] CREATEDB Where ??
I am pretty new to PostgreSQL so please bare with me :-) When issuing the CREATEDB MyDb then creating some tables with CREATE TABLE, I then go back and do a search for the file I have just created (MyDb) but can't find the physical file. Does one actually exist ?? Pete ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl