Re: Numerical DB/Table Names
От | Joe Conway |
---|---|
Тема | Re: Numerical DB/Table Names |
Дата | |
Msg-id | 001601c13d75$b88e3540$0205a8c0@jecw2k1 обсуждение исходный текст |
Ответ на | Numerical DB/Table Names (Jeff Brickley <jeff.brickley@motorola.com>) |
Список | pgsql-general |
> upgrading to 7.1.3 but have run into a problem. All of the databases > are stored with numerical names in the /$prefix/base directory. They > seem to be stored as binaries so I am unable to open any files under > that directory. I know that in our 7.0 version of PostgreSQL all > databases have a directory under the /$prefix/base directory that is > labeled as the name of the database. Inside each database directory the > physical data is stored in files that have the same name as all the > relationships in the database. I can still insert and retrieve data > from any database created on this new 7.1.3 cluster but am not > comfortable with not being able to read the data files. > Has anyone encountered this problem? Thanks in advance for any help you > can provide. In 7.1+ the directories and files are named by their OIDs. See the README in contrib/oid2name for more information. I haven't used it myself, but the oid2name contib should let you more easily associate the OID names with the database object names. Hope this helps, -- Joe
В списке pgsql-general по дате отправления: