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]
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 ??
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])