[postgres bin]$ postmaster start /usr/bin/postmaster does not know where to find the database system data. You must specify the directory that contains the database system either by specifying the -D invocation option or by setting the PGDATA environment variable.
[postgres bin]$ pg_ctl start pg_ctl: No database directory or environment variable $PGDATA is specified
tar.gzを展開する場合はconfigureすると、以下のエラーです。 NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it!
To help you a bit, I am now going to create the needed MySQL databases and start the MySQL server for you. If you run into any trouble, please consult the MySQL manual, that you can find in the Docs directory.
Sorry, the host 'localhost' could not be looked up. Please configure the 'hostname' command to return a correct hostname. If you want to solve this at a later stage, restart this script with the --force option
んで、MySQL も innoDB のおかげでトランザクション処理を可能にしたし 大規模 DB でのパフォーマンスも上げてきたしね。
しっかし、MySQL 4.0 のリファレンスマニュアルにある For the upcoming MySQL Server 4.x releases, expect the following features now still under development:
Mission-critical, heavy-load users of MySQL Server will appreciate the additions to our replication system and our online hot backup. Later versions of 4.x will include fail-safe replication; already existing in 4.0, the LOAD DATA FROM MASTER command will soon automate slave setup. The online backup will make it easy to add a new replication slave without taking down the master, and have a very low performance penalty on update-heavy systems. って本当かいな。
psqlコマンドラインからのクエリは成功するのに Pg使ってPerlで$conn->exec("$query")するとPGRES_FATAL_ERRORになります。 クエリはselect * from table where keyword='hoge'くらいの単純なものです。 こういう場合のデバッグってどうやったらいいですか？