[GENERAL] PostgreSQL 32 bit DB on 64 bit machine

Can a 32 bit PostgreSQL v. 9.0 db be copied from a 32 bit machine and overwrite the db on a 64 bit PostgreSQL machine? I'm trying to get a good initial starting point before performing hot standy write ahead logging (WAL) replication between a 32 bit and 64 bit machine. When I copy the 32 bit

[GENERAL] PostgreSQL 32 bit DB on 64 bit machine

Can a 32 bit PostgreSQL v. 9.0 db be copied from a 32 bit machine and overwrite the db on a 64 bit PostgreSQL machine? I'm trying to get a good initial starting point before performing hot standy write ahead logging (WAL) replication between a 32 bit and 64 bit machine. When I copy the 32 bit

[GENERAL] Need help on extracting composite array element in ‘C’

I am having an issue with extracting data from the arguments within my ‘C’ function, inside my Stored Library. Let’s put the pieces together first: I have a type called rank_post which has two one character fields: CREATE TYPE rank_post AS ( rank character(1), post character(1) ); I am usin

[GENERAL] (no subject)

Hi List; I've created a plperlu (perl untrusted) function with the ability to use dbi. I can use the code listing below to return data if I specify the query as follows: select * from sybase_get2() as (f1 varchar(100), f2 varchar(100)); However, I have to specify the column names as f1 and f2. I

[GENERAL] How to install PL/perlU (perl untrusted)

Hi List;   I found documentation that talks about untrusted perl here: http://www.postgresql.org/docs/8.1/interactive/plperl-trusted.html   However I do not know how to install/use untrusted perl.   Can someone point me in the right direction?   Thanks in advance...

[GENERAL] PL/Perl questions...

Hi List;   I have 2 questions...   1) I want to create a perl function which connects to an external non-Postgres database and retrieves data. I wonder is the best way to do this to return a set or an array? I assume returning a data set is a better way to go, I want to be able to run something lik

Re: [GENERAL] postgres password

You cannot use the postgres account without some tweaks, Sorry I don't remember where I found this info - somewhere in the pgadmin install docs.   Create a new superuser with a password, add connectivity to the pg_hba.conf file if needed and pgadmin should work fine - Original Message -

[GENERAL] Compiling contrib dblink_tds and oralink

Hi List; I've downloaded and unzipped the dblink_tds and the oralink contribs from the pgfoundry. Once I move them into the contrib directory and try to run make I get errors about undeclared functions (see the listing below). Any C guru's have any thoughts/advice/etc?? Thanks in advance for yo