主页 / user-16513

DarkCoffee's questions

Martin Hope
DarkCoffee
Asked: 2013-07-14 15:45:05 +0800 CST
  • 2

我在 postgresql 9.1（http://doxygen.postgresql.org/postgres_8c_source.html#l00829第 1094 行）的 postgres.c（在 exexc_simple_query 内部）工作。我需要在一个表中插入一些查询信息，稍后我将检查该表。我正在尝试使用这三行通过 SPI 来实现：

SPI_connect();
SPI_exec("INSERT INTO testvalues (11,6)", 5);
SPI_finish();

但是当我启动服务器并发送查询时，出现分段错误：

LOG:  server process (PID 13856) was terminated by signal 11: Segmentation fault
LOG:  terminating any other active server processes
WARNING:  terminating connection because of crash of another server process
DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and repeat your command.
FATAL:  the database system is in recovery mode
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted; last known up at 2013-07-14 00:40:22 CEST
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  record with zero length at 0/17D7368
LOG:  redo is not required
LOG:  autovacuum launcher started
LOG:  database system is ready to accept connections

你知道我该如何解决吗？有没有更好的方法从 postgres.c 插入数据？

postgresql database-internals
Martin Hope
DarkCoffee
Asked: 2013-02-10 22:35:33 +0800 CST
  • 1

我正在研究 postgresql 代码（服务器端）。我按照官方教程从源代码安装了一个版本： http ://www.postgresql.org/docs/8.4/interactive/install-short.html

我对代码做了同样的修改，所以我需要再次安装 postgresql，但这次是我的版本。

我在/usr/local/pgsql2/中重命名了/usr/local/pgsql /并且我做到了：

make distclean
./configure
make
sudo make install
sudo mkdir /usr/local/pgsql/data
sudo chown darkcoffeelinux /usr/local/pgsql/data

直到现在一切都很顺利，但是有了命令

/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data/

我收到了这个错误：

The files belonging to this database system will be owned by user "darkcoffeelinux".
This user must also own the server process.

The database cluster will be initialized with locale en_US.UTF-8.
The default database encoding has accordingly been set to UTF8.
The default text search configuration will be set to "english".

fixing permissions on existing directory /usr/local/pgsql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 24MB
creating configuration files ... ok
creating template1 database in /usr/local/pgsql/data/base/1 ... ok
initializing pg_authid ... Segmentation fault (core dumped)
child process exited with exit code 139
initdb: removing contents of data directory "/usr/local/pgsql/data"

附加信息：我使用的是 kubuntu，postgresql 8.4.15

postgresql linux
Martin Hope
DarkCoffee
Asked: 2012-12-29 11:39:05 +0800 CST
  • 0

当我从源代码安装 PostgreSQL 时，我必须安装 libreadline.so.6 库。
从那一刻起，我无法更新我的 kubuntu 系统。

错误是：

Setting up ubuntu-keyring (2011.11.21.1) ...

gpggpg: symbol lookup error: /usr/local/lib/libreadline.so.6: undefined symbol: UP

: symbol lookup error: /usr/local/lib/libreadline.so.6: undefined symbol: UP
dpkg: error processing ubuntu-keyring (--configure):
 subprocess installed post-installation script returned error exit status 127

Errors were encountered while processing:
 ubuntu-keyring
 E: Sub-process /usr/bin/dpkg returned an error code (1)'

出于这个原因，我想删除 libreadline.so.6

如果我这样做，我的 PostgreSQL 会发生什么？它们对我的项目都很重要。

编辑

我检查了我的系统并有：

在/usr/local/lib三个文件中：

libreadline.so
libreadline.so.6
libreadline.so.6.2

并在/usr/lib/x86_64-linux-gnu/：

libreadline.so

这些是什么？PostgreSQL 使用其中哪一种？

postgresql installation
Martin Hope
DarkCoffee
Asked: 2012-12-28 23:22:07 +0800 CST
  • 3

我将 PostgreSQL 9.2 与我的 Web 应用程序一起使用，该应用程序具有三个带有三个选择的 servlet。

我打开日志。

当我发送我的第一个查询时：select * from "Nomi" limit 4

在它之前，日志向我显示了另一行：

execute <unnamed>: SET extra_float_digits = 3

这个命令是什么？

postgresql postgresql-9.2