Обсуждение: 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
Peter Moscatt <pmoscatt@bigpond.net.au> 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.
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" <pmoscatt@bigpond.net.au> To: <pgsql-hackers@postgresql.org> 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
> 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" <pmoscatt@bigpond.net.au> > To: <pgsql-hackers@postgresql.org> > 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 pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026