On Fri, 8 Feb 2008, David Wall wrote:
Does pg_standby take care of this by checking file sizes or the like? In my
testing with scp, we never experienced any problems, but I wonder if we were
somehow "just lucky."
pg_standby only processes files of exactly the length they're supposed to
be.
On Sat, 9 Feb 2008, Roberto Scattini wrote:
-a "WAL segment file" is the same that a "log file segment"?
Yes: WAL="write-ahead log".
-how often a new WAL file is generated? this depends on the server load?
These are the WAL segment files that are produced by the database, the
ones you're
That's correct. You have to do it that way or the system in recovery
mode can start to consume the new segment file before it has been
completely copied over yet.
Does pg_standby take care of this by checking file sizes or the like?
In my testing with scp, we never experienced any problems
On Fri, 8 Feb 2008, David Wall wrote:
Is 'scp' by itself considered an "atomic tool" for copying files to the
standby server? Does "atomic" mean that the program should copy a file over
using a temp file name and then renames at the end or does it mean something
else?
That's correct. You h
2) if archive_command is activated and working, the primary
server sends (preferably with rsync or some other "atomic tool") the
NEW WAL files to the standby server. Later, at some point, the primary
server will delete this files when considers that are not necessary
anymore.
Is 'scp'
In article <[EMAIL PROTECTED]>,
Rowan <[EMAIL PROTECTED]> wrote:
>Postgres 8.2 using php5
>
>what is the simplest way to request column names ?
The pg_field_name is simple:
http://us3.php.net/manual/en/function.pg-field-name.php
---(end of broadcast)--
hi list:
im working in the setup of a warm standby server. im using
postgres-8.2.5 in the slave and 8.2.4 in master right now, in
production it will be only 8.2.5, everything in debian etch.
we decided this solution because we want an easy to
migrate/implement/adminstrate backup sever, and we have
Joshua D. Drake escribió:
> Richard Broersma Jr wrote:
>> --- On Wed, 11/21/07, Stephen Frost <[EMAIL PROTECTED]> wrote:
>>> I've got a real desire for a PG polo. :) One which I could wear to
>>> work (business casual or whatever) would seriously rock.
>>
>> That's what I like to do. The dress-co
On Feb 8, 2008 3:21 PM, Alan Hodgson <[EMAIL PROTECTED]> wrote:
>
> On Friday 08 February 2008, "Hua-Ying Ling" <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I'm trying to install postgresql in a custom directory. when I run rpm
> > --prefix I'm getting a package is not relocatable error. Suggestion
On Friday 08 February 2008, "Hua-Ying Ling" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm trying to install postgresql in a custom directory. when I run rpm
> --prefix I'm getting a package is not relocatable error. Suggestions on
> how do I get around this?
Build your own package, or install from so
Hi,
I'm trying to install postgresql in a custom directory. when I run rpm
--prefix I'm getting a package is not relocatable error. Suggestions on how
do I get around this?
Thanks
Hua-ying
On Feb 8, 2008 9:06 AM, Andrej Kastrin <[EMAIL PROTECTED]> wrote:
> The answer is simple no. I know I can to some preprocessing on input
> files using awk, sed etc. but don't want to change the structure of the
> file.
If the problem is that you have | characters in your data, then can
you change
Bruce Momjian <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] wrote:
>> Has someone encountered a problem using pqlib in a multi-threading
>> application (POSIX or Win32) when the Intel Hyperthreading is enabled?
>> Disabling the hyperthreading option from the bios of the computer all works
>> fine
On Feb 5, 9:11 am, "Дикий неадекватный кальмар"
<[EMAIL PROTECTED]> wrote:
> is there a way to catch error returned by EXECUTE statement?
>
> declare stmt character varying;
> begin
> stmt=crate user||'some_name'||' with password '''||'somepassword';
> execute stmt;
>
> end;
>
> here i need to know
What I'd like to know is if there is an easy to way to use the full
text index to generate a list of the most common words. I could write
this code manually, but I'm hoping there's a better (simpler) way.
For 8.3
http://www.postgresql.org/docs/8.3/static/textsearch-features.html#TEXTSEARCH-STAT
your life is a hard drive, Christ can be your backup. +
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
A San Valentino HIT damore e teneri Sfondi per il tuo cell.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=7548&d=20080208
Hi,
we have a 8.2.1 database that has a Latin1 encoding.
We managed to write there UTF-8 data (not Latin1) and, as this version
of the database, was actually allowing everything to be written to the
Latin1 database, by now we have a problem of having data in different
encoding on that database. I
I'm a bit of a novice writing tsearch2 queries, so forgive me if this
is a basic question.
We have a table with 2million+ records which has a considerable amount
of text content. Some search terms (such as comedy, new, news, music,
etc.) cause a significant performance hit on our web site. There
Andrej Kastrin wrote:
Colin Wetherbee wrote:
Andrej Kastrin wrote:
||5354235||,||some text...|| ||1234567||,||some text...||
||1234568||,||some text...||
The sql statement I defined was:
COPY testtable FROM 'test.txt' WITH DELIMITER AS ',' CSV QUOTE AS
'||';
but the error:
ERROR: COPY quo
[EMAIL PROTECTED] wrote:
> Hi all.
> Has someone encountered a problem using pqlib in a multi-threading
> application (POSIX or Win32) when the Intel Hyperthreading is enabled?
> Disabling the hyperthreading option from the bios of the computer all works
> fine, otherwise the threaded application d
The answer is simple no. I know I can to some preprocessing on input
files using awk, sed etc. but don't want to change the structure of the
file.
Colin Wetherbee wrote:
Andrej Kastrin wrote:
||5354235||,||some text...|| ||1234567||,||some text...||
||1234568||,||some text...||
The sql stat
Andrej Kastrin wrote:
||5354235||,||some text...|| ||1234567||,||some text...||
||1234568||,||some text...||
The sql statement I defined was:
COPY testtable FROM 'test.txt' WITH DELIMITER AS ',' CSV QUOTE AS
'||';
but the error:
ERROR: COPY quote must be a single ASCII character
I guess I'
Hi.
use set client_encoding=''SJIS be the same to export PGCLIENTENCODING=SJIS.
But can not export the data to csv file corecttly without errror,
just because the character which is not SJIS encoding.
Um, Please show the information on your database of 7.3.
ex)
postgres=# \l
List of
Hi.
Oh ok,
About the data in a database.
From the pre- report, you are operating by UTF-8. Therfore,
you should take it out by UTF-8 first. It is reload to new 8.3 of UTF-8.
Then, conversion does not occur there.
To the next.
when SJIS is required by the client , some character codes may not
I think i can export olddb(7.4) by encoding SJIS,
but can not import it into new db(8.3) for some unregular sjis character.
And
I create the database by encoding UTF-8 .
---
createdb -E UNICODE db
---
I think it is the same to set PGCLIENTENCODING=UTF-8
.
use set client_encoding=''SJIS be the same
Dear all,
I have to copy the file with the following delimiters into the database:
||5354235||,||some text...||
||1234567||,||some text...||
||1234568||,||some text...||
The sql statement I defined was:
COPY testtable FROM 'test.txt' WITH DELIMITER AS ',' CSV QUOTE AS '||';
but the error:
ER
di Email Marketing di Email.it
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=7484&d=20080208
ok, that explains.
so i go on with my test, which still doesn't turn out as i expected
(PostgreSQL 8.1.10).
why??
==in TTY1== (start.sql)
create table test (id int4 primary key); --expect sucess
insert into test (id) values (1); --expect success
==in TTY2== (tr1a.sql)
begin; --expect success
drop
In article <[EMAIL PROTECTED]>,
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Thu, 7 Feb 2008, Harald Fuchs wrote:
>> This works fine in 8.2.4, but 8.3.0 rejects the ALTER TABLE with the
>> following (somewhat misleading) error message:
>>
>> ERROR: insert or update on table "t2" violates forei
Oops again..
or
--
set PGCLIENTENCODING=SJIS
pg_dump
or
copy of psql's.
--
However, an environmental setup is as follows again.
export PGCLIENTENCODING=SJIS
:-)
Regards,
Hiroshi Saito
- Original Message -
From: "Hiroshi Saito" <[EMAIL PROTECTED]>
Hi.
- Original Message --
Hi.
- Original Message -
From: "bh yuan" <[EMAIL PROTECTED]>
Thanks for your replay.
The "0xe9ab99" is not SJIS nor SHIFT_JIS_2004.
Ahh Ok, you already understood. :-)
But I shoud export data with not regular SJIS character
from old database(7.4.3) to new database(8.3),
and us
Thanks for your replay.
The "0xe9ab99" is not SJIS nor SHIFT_JIS_2004.
But I shoud export data with not regular SJIS character
from old database(7.4.3) to new database(8.3),
and use the old programe which export data as SJIS encoding .csv file.
Can I modify conf file to ignore the error?
or check
32 matches
Mail list logo
