Hi,
What are steps/code for Record-based Log Shipping postgres 8.2?
If use Record-based Log Shipping can I access both primary and standby
server simultaniously.
Tarun
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.o
What are the advantages to SQL Functions? I'm looking to optimize
'default' PostgreSQL environments for clients. I'm writing an
application and looking to put functions to optimize just that table,
etc. They don't want to have a full-time database admin (surprise!).
Thanks,
J
-
Joshua D. Drake wrote:
Use a connection pooler like pgpool.
Thanks for the suggestion, I will look into it and test. There seems to
some overhead using that tool. What about custom functions, written in
SQL or C? They seem to work until the database is shut down, any
thoughts about that for a c
I'm writing a web application inwhich clients will login/out among other
stuff. I have be reading on prepared statements and leave you all with
an open-ended question. Are prepared statements better and how can I
program them to not end at the once the session is over?
Thanks, any other sugges
Do you mean PREPARE / EXECUTE?
/* [EMAIL PROTECTED]:5432/ahammond =# */ \d foo
~ Table "public.foo"
~ Column | Type | Modifiers
- +-+--
~ foo_id | integer | not null default nextval('foo_id_seq'::
I'm new to PostgreSQL, and am wondering for BindSQL is intergrated in
Postgres or in the future for version 8.
Example:
SELECT * FROM sample_table WHERE computer = :1;
Any pointers will help.
Thanks,
J
---(end of broadcast)---
TIP 1: subscribe and u
