I am trying to use pgreplicator and after (FINALLY)
seeming to have the program running, I run into an error loading pltcl.so
somewhere in the code. The following error is sent to me from the
backend:
ERROR: Load of file
/home/postgres/lib/pltcl.so failed: dlopen '/home/postgres/lib/pltc
You can display a lot of debug info setting up loggin. Make the following
changes in your postgresql.conf file for some basic logging. The higher up
you go with the debug level, the more info you'll get.
debug_level = 2 # range 0-16
debug_print_query = true
debug_pretty_print =
Indices:
dioh_iminvf_inventory ==> Indices: dioh_iminvf_idx_itemno,
dioh_iminvf_idx_store
dioh_imitmf_itemmaster ==> Indices: dioh_imitmf_idx_itemno,
dioh_imitmf_idx_vendno
dioh_imvitf_vendoritem ==> Indices: dioh_imvitf_idx_itemno,
dioh_imvitf_idx_vendno
dioh_samohf_saleshistory ==> Indices: di
Hallo,
I'm working on porting Oracle schema to PostgreSQL. Now I habe the whole
schema in PostgreSQL. But there are some problems in our application in
some sql queries. I get following errors.
ERROR: Unable to identify an operator '<=' for types 'numeric' and 'double
precision'
You
Hi all,
I am running the following query. It processes most of the locations fine
($Req_Store), however, on one of the locations, it takes almost 3 days to
run when it should take only about a half hour. (The query is rerun for
each location ($Req_Store)).
$result = $conn->exec("
declare my
On Wed, Oct 02, 2002 at 02:20:39PM -0400, Raymond Chui wrote:
> Everything is running fine, except take long time to finish.
> Because some tables stored values from 50,000 to 100,000 rows
> Some deletion need to deleted up to 45,000 rows.
how often do you make this "delete" process?
do you vacuu
Hi,
check this link:
http://usogres.good-day.net/
C.
Wojciech Bernacki wrote:
> My online app uses PostgreSQL 7.2 running on a single Debian box. I also have
> a spare machine witch may act as a backup server. After even hardware
> breakdowns the whole system must be up and running in no
