Search Postgresql Archives

Hi,

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

I am a new user testing this open-source database and I have a few
questions.  I was able to install PostgreSQL version 8.1.3 on Linux
version 9 using the simple install script provided.  I created a simple
database and populated the database with some data.  The inserts,
select, delete, drop, etc. commands work great.  So I was testing the
back up process and ran into a few problems.  When I ran the pg_dump it
said my pg_dump version was outdated and that I need to use the option
-i.  When I did I get "pg_dump: server version: 8.1.3; pg_dump version:
7.4.8"  

1 Why are the version different?  I have no other installs of this
product.

The dump also failed with this error:

Error message from server: ERROR: column "datpath" does not exist
The commend was: SELECT (SELECT username FROM pg_user WHERE usesysid =
datdba) as dba, pg_encoding_to_char(encoding) as encoding, datpath FROM
pg_database WHERE datname = "test"

2 There is no reference to what "datpath" is?  Can some one explain
what it is, used for, and what to set it to?

Brian


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux