[ADMIN] compiling 7.4 --with-java

Hi, I try to rebuild my pg 7.4 to get generated jdbc driver. If I run gmake it stops with error (without --with-java option I do not have any problems to complite it). I send the error message (one part from message): gmake[5]: Nothing to be done for `all'. gmake[5]: Leaving directory `/pginst/po

[ADMIN] pg_dump and schemas

pgSql 7.4.0 Hi, Suppose, there are two (2) schemas in the database: schemaA and schemaB. schemaA is relatively small and updated all the time, schemaB is huge and updated occasionally, maybe several times a day. The whole database, with schemaA and schemaB, is dumped once a week, say Sunday, and

[ADMIN] Sending a libpq C function variables through function call

Hi all, I've got a function in PG set up, the libpq C call goes like this: PERFORM funcName(''t1'', ''t2'', ''t3'', ''t4'', NEW.someInteger, NEW.someBoolean) funcName looks like this: create function funcName(text, text, text, text, int, boolean) returns int as '/var/lib/postgres/

[ADMIN] Cast text to bytea

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I want to change a column from text to bytea; since it seems that alter table can't change the column type, i have to add a temporary column and copy the data from the old one to the new, delete the old and rename the new. But it seems that Post

Re: [ADMIN] Cast text to bytea

Title: RE: [ADMIN] Cast text to bytea Have you seen this? http://www.postgresql.org/docs/current/static/datatype-binary.html Maybe you need some backslashes? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Alvar Freude Sent: Tuesday, December 02, 2

[ADMIN] PGSQL and DNCL

Has anyone any experience with PGSQL 7.x and implenting the FTC do-not-call list - which is about 50 million 10 digit N. American phone numbers? If so what structures have you used and what have you done interms of performance tweaks? Is there an equivalent to Oracle's IOT (index organized tabl

Re: [ADMIN] Sending a libpq C function variables through function

Kris Kiger writes: > I'm not sure if there is a good way to pass parameters through libpq, > or will I have to use something like SPI to grab them? Use of libpq is > preferable, but not absolute. I appreciate the input! There is no choice: libpq connects to a remote database as a client; SPI p

[ADMIN] incremental backup

hi there is any utility or command in postgresql for incremental backup or incremental restore. plz. help me. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere"

[ADMIN] downgrading to 7.3.2 from 7.4.1 under Cygwin

Hi Folks, I've refreshed my Cygwin distribution and haven't noticed that postgres is also being upgradeing. So it has been upgraded to version 7.4.1. Starting "pg_ctl start -D /usr/local/psql/data -m fast 2>&1 &" sends an error message like this: $ FATAL: database files are incompatible with ser

Re: [linux-lvm] RE: [ADMIN] [PERFORM] backup/restore - another

xfs_freeze is a userspace program included in the xfsprogs rpm. It does run on Redhat 7.3 (the SGI supplied kernels and userspace for RedHat 7.3 are somewhat dated; I'd suggest patching the 2.4.21 kernel with XFS 1.3.1 patches and upgrading the userspace programs from the SRPMS). Post to the linux-