Hi everyone,
when i issued the following command: pg_dump -d mydb -Fc -Z9 -U dbadmin >
base_backup.tar
i keep getting warning messages: pg_dump: [custom archiver] WARNING: ftell
mismatch with expected position -- ftell used.
Do i have to be worried about that, i.e. can it happen that the backup
Hi,
I have set up a postgreSQL on a x86 Solaris 10 box with compiling the source code 8.1.4. My application is need to store the characters encoding with GB18030 or GBK. My Solaris box is installed the locale code zh_CN.GB18030 but I fail to initdb -E GB18030 so I have to use the EUC_CN to initd
On Tue, Oct 03, 2006 at 04:16:36PM +0800, stevegy wrote:
> I have published my application since a month and I notice the appcation
> server report a few jdbc errors that says :
> org.postgresql.util.PSQLException: ERROR: character 0xe28094 of encoding
> "UTF8" has no equivalent in "EUC_CN"
> I t
Hi all,
- What does the shared_buffers setting do ?
- Does it mean that that the postgres cannot access most of the physical RAM
but limited to the memory setting (shared_buffers) specified ?
- How do i relate and set max_connections and shared_buffers?
- Is there a thumb rule to determine shared
"Wyatt Tellis" <[EMAIL PROTECTED]> writes:
>>> I'm running 8.1.4 on W2K3 R2. I occasionally get errors of the type:
>>> ERROR: could not open relation 1663/856689/856777: Invalid argument
> I was able to figure out the table name, but is there a way to figure
> out which file caused this error?
Hello all,
As part of my research work, I was looking at the text-retrieval
capability of PostgreSQL.
As I see there are three resources:
-- http://techdocs.postgresql.org/techdocs/fulltextindexing.php
-- tsearch2
-- OpenFTS (which looks like a frontend for tsearch2).
I couldnt understand th
Maybe pg_trgm contrib.-- William Leite Araújo
"Christian Rengstl" <[EMAIL PROTECTED]> writes:
> when i issued the following command: pg_dump -d mydb -Fc -Z9 -U dbadmin >
> base_backup.tar
> i keep getting warning messages: pg_dump: [custom archiver] WARNING: ftell
> mismatch with expected position -- ftell used.
This is definitely not very
Problem:
PostgreSQL "Service" is not runing on a Linux Box,
but I have a database on the Linux Box, that I want
to relocate to another machine, Windows or Linux.
Question:
What files do I need to transfer to get this to work?
Brian
---(end of broadcast)-
Hello -
I have a schema setup which I want to use partitions with. The intent is
to partition based on the "created_at" column, seperating based on the
year/month. What I am struggling with is a rule that I can use to
automatically determine which partition data should be inserted into, such
On Oct 1, 2006, at 11:56 AM, Tom Lane wrote:
OK, that kills the theory that the leak is triggered by subprocess
exit.
Another thing that would be worth trying is to just stop and start the
postmaster a large number of times, to see if the leak occurs at
postmaster exit.
On FreeBSD I'm not s
Jonathan Vanasco <[EMAIL PROTECTED]> writes:
> except instead of relying on a leak to increase memory, I'd like a
> rather intensive large function with a dataset to consumer massive
> amounts of ram. I just can't think of any function to do that.
Sort a big chunk of data with a high work_mem
[EMAIL PROTECTED] ("Brian J. Erickson") writes:
> Problem:
> PostgreSQL "Service" is not runing on a Linux Box,
> but I have a database on the Linux Box, that I want
> to relocate to another machine, Windows or Linux.
>
> Question:
> What files do I need to transfer to get this to work?
The raw da
Hi all,
I have a small coding problem where my function is becoming, well, too
ugly for comfort. I haven't finished it but you will get picture below.
First a small description of the purpose. I have an aggregate function
that takes a string and simply concatenates that string to the previou
On Oct 1, 2006, at 12:24 PM, Fred Tyler wrote:
It is not from the exit. I see the exact same problem and I never
restart postgres and it never crashes. It runs constanty and with no
crashes for 20-30 days until the box is out of memory and I have to
reboot.
my theory, which i hope to prove/di
Well, first off, this would be much easier in one of the other pl's such
as for perl or ruby. Using plpgsql, I would suggest using more of the
string function split_part since you know the delimiters the string can
split on, using str_pos just to verify that there is say a '/' in a part
of the
Hi,Thank you for your reply.I guess you mean right. I am continuing find the solution now.I print all the current locale on my solaris here:===-bash-3.00# localeLANG=zh_CN.GB18030LC_CTYPE="zh_CN.GB18030"LC_NUMERIC="zh_CN.GB18030"LC_TIME="zh_CN.GB18030"LC_COLLATE=
Yes, patches! Seriously, someone from the performance list and/or
hackers should be actively collecting data from discussions
regarding changes to the postgresql.conf file. We really need
someone on top of this to write the annotated postgresql.conf
for 8.2. Josh seems to have no time to do it
On 2006-10-03, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I have a small coding problem where my function is becoming, well, too
> ugly for comfort. I haven't finished it but you will get picture below.
>
> First a small description of the purpose. I have an aggregate function
> t
19 matches
Mail list logo
