On Mar 03 06:20, Simon Riggs wrote:
> On Fri, 2006-03-03 at 12:19 +0100, Mario Splivalo wrote:
> > When I connect to postgres from PHP or Python or using just psql, I can
> > see full SELECT querries logged, with the actuall values for the
> > parameters.
>
> Those interfaces do not use prepared s
On Fri, Mar 03, 2006 at 10:23:57AM -, Andy Shellam wrote:
> Hi Thomas,
>
> I've been trying to get a similar system up and running, and I have to say
> one point in the documentation isn't particularly clear.
>
> It says that you can string together an almost endless supply of WAL logs to
> r
On Fri, 2006-03-03 at 12:19 +0100, Mario Splivalo wrote:
> We're using JDBC to connect to postgres server. I've setup logging so
> that any query that executes over 100ms gets logged. But, the log file
> looks like this:
>
>
> 2006-03-03 12:17:08 CET [31591] SELECTLOG: duration:
> 253.307 ms s
On Mar 3, 2006, at 12:00 PM, Simon Riggs wrote:
On Fri, 2006-03-03 at 10:23 +, Andy Shellam wrote:
Then you would have to find a method of telling the script
that you wish to bring the database up and it will exit and allow
PGSQL to
come up at the current state with the latest data.
On Mar 3, 2006, at 11:54 AM, Simon Riggs wrote:
On Thu, 2006-03-02 at 16:38 -0600, Thomas F. O'Connell wrote:
Ideally, I'd be able to take a base backup of a production system,
copy it to a remote system, which is also the repository for segment
files generated by archive_command, and complete
On Fri, 2006-03-03 at 10:23 +, Andy Shellam wrote:
> Then you would have to find a method of telling the script
> that you wish to bring the database up and it will exit and allow PGSQL to
> come up at the current state with the latest data.
> Replication sounds like a better option
If you w
On Thu, 2006-03-02 at 16:38 -0600, Thomas F. O'Connell wrote:
> I'm administering a database that is not immediately a good candidate
> for replication via Slony. As an interim solution, I'd like to give
> PITR a shot. The primary goal is to have a failover scenario that
> allows for recovery
"Mr. Dan" <[EMAIL PROTECTED]> writes:
> I have checkpoint_segments set to 18, yet I have 38 segmnet files in
> pg_xlog. Is there a reason for that?
The normal steady state is about 2N segment files, because we keep the
last two checkpoints' worth of WAL data.
regards, to
postgresql 8.1.0
Hi,
I have checkpoint_segments set to 18, yet I have 38 segmnet files in
pg_xlog. Is there a reason for that?
Thanks in advance,
~DjK
# WRITE AHEAD LOG
#---
# - Settings -
#fsync = on
[EMAIL PROTECTED] wrote:
> Hi,
>
> Is it possible to set a custom session variable and/or global variable in
> plpgsql ?
No. You can create a temporary or non-temporary table and select from
that.
--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com
+ If you
Peter Eisentraut wrote:
Am Donnerstag, 2. März 2006 16:53 schrieb Olivier Boissard:
I would like to call an external "shell" script from a trigger.
I use actually pgplsh. It works fine but there is a lot of problem with
special characters.
Details please.
In addition I can not co
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Given, Robert A wrote:
| We are beginning to implement uPortal on Postgresql 7.4.8 on a
| z/Linux server. We are interested in obtaining information pertaining
| to any modification of the configuration parameters as distributed
| with the DBMS.
We're using JDBC to connect to postgres server. I've setup logging so
that any query that executes over 100ms gets logged. But, the log file
looks like this:
2006-03-03 12:17:08 CET [31591] SELECTLOG: duration:
253.307 ms statement: EXECUTE [PREPARE: select * from
create_mt_sms_message($1,
Hi,
Is it possible to set a custom session variable and/or global variable in
plpgsql ?
Regards,
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
I have used PostgreSQL on XP, and there's very little (if any) operational
difference. Since XP and 2003 are essentially the same base OS, I'm pretty
confident you won't run into any problems.
Regards
Andy
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andy ,
>
> What in particular were you looking for info on?
>
Since I have never deployed PostgreSQL on Windows 2003, against the
fact that I have tested and used PostgreSQL extensively on Windows XP.
Just wanted to ask this question. Such that if someone had faced a
problem of any kind I be pre
Hi Thomas,
I've been trying to get a similar system up and running, and I have to say
one point in the documentation isn't particularly clear.
It says that you can string together an almost endless supply of WAL logs to
replay against a database, however you must always start from a base backup
-
Hi Vishal,
Yes I have PG 8.1.3 running on Windows 2003 Standard Edition on my
development server. I've had no problems whatsoever with it, from
installation of 8.0 about 3 months ago to upgrading to the latest version.
What in particular were you looking for info on?
Cheers
Andy
-Original
Dear All ,
Has anyone installed succesfully PostgreSQL 8.1.X branch on windows
2003. If yes would you please share your experience
--
With Best Regards,
Vishal Kashyap.
http://www.vishal.net.in
---(end of broadcast)---
TIP 5: don't forget to incre
19 matches
Mail list logo
