Hi,
I have been running PG for quite a while now.
Suddenly, the postmaster either hogs up memory or just croaks and
doesn't respond. The write process has become horribly slow.
Could it be that my data has grown so large that it's becoming an
issue? Even connecting to PGSQL as postgres user in
SHIFT_JIS_2004 is different to SJIS.
But when I use SJIS, I occur the same problem,
so I try SHIFT_JIS_2004.
= set client_encoding='SJIS';
SET
= select * from tablexx;
ERROR: character 0xc2a0 of encoding UTF8 has no equivalent in SJIS
too confused...
Thanks
2008/2/13, Tatsuo Ishii [EMAIL
I am having problem installing the postgre vre 8.2 in windows vista. during the
installation period it displays the error mesage user postgres cannot be
created access denied and suddenly the installation fails. please give me
suggestion in this regard.
-
Hi,
Yes I know that SPSS can do this - in fact that is the only way I could solve
this so far, but that is a very expensive workaround for anybody not currently
owning SPSS.
Thanks.
SWK
-Original Message-
From: jr [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 13, 2008 1:31 PM
Hi,
ye, hundreds of columns - but there is no helping it, that’s the way many
questionnaire are and the representation of the responses (when not in a
database) is always one person per row. I would need this for exporting, but
also to show results online.
Although it’s a good idea I am afraid
Yes, once I have the select outputting it to CSV is not a problem. As you say
PG handles that nicely.
Thx
SWK
-Original Message-
From: Reece Hart [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 13, 2008 9:39 PM
To: Tino Wildenhain
Cc: SunWuKung; pgsql-general@postgresql.org
First, i apologize, my english skills is very, very poor.
---
i have many tables in many schemas with default value like that: DEFAULT schema.function(...).
i need backup all databases and i need restore it.
IF YOU WANT UNDERSTAND ME, YOU NEED DO THIS:
YOU TRY RESTORE _DB_TEST_.PGB FILE
Hello,
I have a question regarding SLONY replication. In short, the question is: Can I
have different values on every node in the sl_path table in column
pa_conninfo?
For example, one node has IP addresses in pa_conninfo, but other has aliases
from /etc/hosts?
More detailed description:
I
am Thu, dem 14.02.2008, um 7:35:15 + mailte First NameBipllab Roy
folgendes:
I am having problem installing the postgre vre 8.2 in windows vista. during
the
installation period it displays the error mesage user postgres cannot be
created access denied and suddenly the installation
this is really bugging me.
am i doing something stupid?
On Fri, Feb 8, 2008 at 2:18 PM, Willy-Bas Loos [EMAIL PROTECTED] wrote:
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
On Thu, 14 Feb 2008, Phoenix Kiula wrote:
Suddenly, the postmaster either hogs up memory or just croaks and
doesn't respond. The write process has become horribly slow.
You should consider whether that's because a checkpoint is happening at
that point. You didn't mention anything about your
Balázs Klein wrote:
Hi,
Yes I know that SPSS can do this - in fact that is the only way I
could solve this so far, but that is a very expensive workaround for
anybody not currently owning SPSS.
Huh, perhaps you could try with PSPP ... (I don't know if it can do it,
but I know it is supposed
Hello list,
Just joined, read the archives, but couldn't find a solution to my
problem. My question is: 'How can I best determine when to delete
data?'. Hopefully this is the right place to ask, otherwise kindly
redirect me to the proper list.
The situation is as follows: we use PostgreSQL
[Please copy the mailing list on replies so others can contribute
to and learn from the discussion.]
On Thu, Feb 14, 2008 at 09:56:36AM +0100, Hermann Muster wrote:
The statement I'm using is the following:
SELECT
Hello list,
predictable. Sometimes a lot of data is stored over a period of a few
days and the disk runs out of free space (this is not theoretical, in
one case it happened already). For this situation we decided that we
I suppose expanding the amount of storage space is not an option?
On Feb 13, 2008, at 2:53 PM, Koen Vermeer wrote:
I'll check to see what the options are for reading in the data in PHP.
Thanks for the help!
If you use prepared statements, you don't need to do anything special
at all for bytea with PHP. No worries about escaping and all that.
Using the
On 14/02/2008, Michiel Holtkamp [EMAIL PROTECTED] wrote:
Hello list,
Just joined, read the archives, but couldn't find a solution to my
problem. My question is: 'How can I best determine when to delete
data?'. Hopefully this is the right place to ask, otherwise kindly
redirect me to the
In response to Michiel Holtkamp [EMAIL PROTECTED]:
Hello list,
Just joined, read the archives, but couldn't find a solution to my
problem. My question is: 'How can I best determine when to delete
data?'. Hopefully this is the right place to ask, otherwise kindly
redirect me to the
Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 11 Feb 2008 18:50:41 -0500 (EST)
Greg Smith [EMAIL PROTECTED] wrote:
I could help out with the initial setup, you could just have somebody
internally do the install and let me have an account when it's ready,
Michael Fuhr schrieb:
[Please copy the mailing list on replies so others can contribute
to and learn from the discussion.]
On Thu, Feb 14, 2008 at 09:56:36AM +0100, Hermann Muster wrote:
The statement I'm using is the following:
SELECT
First off, thank you all for such a quick response. I will reply on
several emails at the same time, because the answers overlap.
Bill Moran wrote:
In response to Michiel Holtkamp [EMAIL PROTECTED]:
Since you don't give any idea how much data is involved, let me iterate
through your choices,
On Thu, Feb 14, 2008 at 12:10 PM, Timur Luchkin [EMAIL PROTECTED] wrote:
I have a question regarding SLONY replication. In short, the question is:
Can I have different values on every node in the sl_path table in column
pa_conninfo?
For example, one node has IP addresses in pa_conninfo, but
On Feb 14, 2008, at 2:04 AM, Balázs Klein wrote:
Hi,
ye, hundreds of columns - but there is no helping it, that’s the
way many questionnaire are and the representation of the responses
(when not in a database) is always one person per row. I would need
this for exporting, but also to
Has anybody had a good experience going from Npgsql to
Corelab:PostgreSQLDirect? I am considering migrating because it offers
support for COPY but I am wondering about other functionality and
performance as well. Any feedback would be greatly appreciated.
Benjamin
Hi,
the part that I don't know is how to put those NULLs in.
It could well be doable I just can't do it myself.
How does the query look like that produces from this input:
PersonID AttributeID Value
1 1 aaa
1 2 bbb
1 3 ccc
2 1 ddd
2 3
On Feb 14, 2008, at 10:34 AM, Michiel Holtkamp wrote:
Peter Childs [reformatted] wrote:
I think you need to know depending on a mix of free disk space and
free space map usage. If you do a standard Vacuum Verbose it will
tell
you how full the fsm is. You need to ensure that you have
Erik Jones wrote:
On Feb 14, 2008, at 10:34 AM, Michiel Holtkamp wrote:
Maybe this is what I'm looking for. Is there any other way to retrieve
information on the fsm usage?
Have a look at the pg_freespacemap contrib package.
Thank you! I will.
Regards,
Michiel
On Feb 14, 2008, at 10:56 AM, Balázs Klein wrote:
-Original Message-
From: Erik Jones [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 14, 2008 5:15 PM
To: Balázs Klein
Cc: 'Tino Wildenhain'; 'SunWuKung'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] dynamic crosstab
On Feb
This is the official announcement for the Suncoast PostgreSQL User
Group (SPUG). You can read the blog here:
http://pugs.postgresql.org/spug
The SPUG serves western central Florida, specifically Tampa, St Pete,
Lakeland, Brandon, Bradenton, Sarasota, and even Orlando. Hopefully
we will have a
On Thu, Feb 14, 2008 at 04:48:33PM +0100, Hermann Muster wrote:
Michael Fuhr schrieb:
COALESCE(UPPER(SUBSTR(X.Firma,1,7)) =
I haven't examined the entire query but the above line appears to
be the problem. Did you mean to write the following?
Jan Wieck wrote:
On 2/12/2008 3:04 PM, Tom Lane wrote:
Nathan Wilhelmi [EMAIL PROTECTED] writes:
Hello - Trying to track down a lock contention problem, I have a
process that does a series of select / insert operations. At some
point the process grabs a series of RowExclusiveLock(s) and
On Feb 14, 2008, at 11:16 AM, Greg Fausak wrote:
Howdy,
I find that user accounts are very good for
helping me protect application access to the database.
That is, instead of giving a user 1 account, I may give hem
10, and each of those accounts are restricted in the database
in different
Is postgresql the only thing using the disk space/partition?
Have you considered running a cron job to parse df output to trigger a
delete when disk usage gets to a set threshold? and thus also account
for any unexpected non-postgresql disk usage.
I would also think you would want to consider
Howdy,
I find that user accounts are very good for
helping me protect application access to the database.
That is, instead of giving a user 1 account, I may give hem
10, and each of those accounts are restricted in the database
in different ways. Anyway, I'm wondering what the maximum number of
On Thu, Feb 14, 2008 at 5:16 PM, Greg Fausak [EMAIL PROTECTED] wrote:
Howdy,
I find that user accounts are very good for
helping me protect application access to the database.
That is, instead of giving a user 1 account, I may give hem
10, and each of those accounts are restricted in the
Greg Fausak [EMAIL PROTECTED] writes:
Can I create a database with 1 million login roles and expect performance to
be good? 10 million?
Probably not, as (to my knowledge) no one has ever done any performance
testing in that domain. I doubt anyone's worked with more than a few
thousand roles.
So, my ill Postgres 8.3 database is filling up log files in the pg_log
directory with the following:
2008-02-13 18:29:31 CST LOG: loaded library
$libdir/plugins/plugin_debugger.dll
2008-02-13 18:29:31 CST LOG: loaded library
$libdir/plugins/plugin_debugger.dll
2008-02-13 18:29:31 CST LOG:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
The speakers committee has voted on the talks and all speakers have
been notified. We have an excellent range of topics that will be
discussed by a number of well known PostgreSQL contributors. We also
have talks from some newcomers as well.
On Feb 14, 2008, at 19:24 , Shane Ambler wrote:
Is postgresql the only thing using the disk space/partition?
There are some other things on the partition, but they don't change
in size.
Have you considered running a cron job to parse df output to
trigger a
delete when disk usage gets
Dan Armbrust wrote:
Are there any known regression issues WRT performance on the 8.3.0.1
binary build for windows?
And I mean serious -multiple orders of magnitude- performance issues
running simple queries on a small database...
A little more background. I built 8.3.0 on Cent OS 5 today.
In response to Michiel Holtkamp [EMAIL PROTECTED]:
On Feb 14, 2008, at 19:24 , Shane Ambler wrote:
Is postgresql the only thing using the disk space/partition?
There are some other things on the partition, but they don't change
in size.
Have you considered running a cron job to
Hi,
I have searched this group and have found where others have reported
issues with initdb.
A couple of our Windows XP SP2 customers are having problems upgrading
to our latest release which includes version 8.2.4 of PostgreSQL.
They are logged on as a local Windows admin. We use the MSI with
On Thu, 14 Feb 2008, Tom Hart wrote:
Are we still waiting on this, or did the discussion move off list?
Waiting--all involved are distracted doing the organization work for the
East conference this week.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
On Fri, 2008-01-25 at 06:01 +1030, Shane Ambler wrote:
I haven't looked into it much but SE-PostgreSQL may be an option for
Bill Moran also pointed out Postgresql Veil PHP Horde:
Veil Project
http://veil.projects.postgresql.org/
Horde Framework:
http://www.horde.org/
Of course, there
inline..
On Thu, Feb 14, 2008 at 1:03 PM, Tom Lane [EMAIL PROTECTED] wrote:
Greg Fausak [EMAIL PROTECTED] writes:
Can I create a database with 1 million login roles and expect performance
to
be good? 10 million?
Probably not, as (to my knowledge) no one has ever done any performance
We are running a Java app with Tomcat 5.0.x and Postgres 8.0.x on a
linux machine: 2.6.16 kernel, dual processor, 16gb ram, 2 scsi drives.
The machine runs a few other ongoing applications that handle
replication, but their impact on performance should be constant over time.
The application
Greg Fausak [EMAIL PROTECTED] writes:
So, your statement that granting permissions on the same object, does
that apply to roles themselves?
The bulk of my permissions boil down to granting a role to a role.
Well, there are not *known* bottlenecks in that, but again it's not
something that's
I can't imagine how I could store data directly that way (beside the usual
thing that whenever I can I aim to store scalar value in a column).
To do what you suggest I could have this:
1 (aaa,bbb,ccc)
2 (ddd,NULL,eee)
but for this I would need to store a NULL for a person for all the questions
Michiel Holtkamp wrote:
Running low on disk space can also happen when something goes wrong
with
the recording trigger (this can be a hardware fault). In both cases,
we
don't want to store even more data, but we will want to make a
selection
based on age (newer data is more
On Feb 14, 2008, at 3:49 PM, Klein Balazs wrote:
My point was to get rid of the the EAV setup. Something like:
CREATE TABLE questions (
question_id serial primary key,
question text not null
);
CREATE TABLE people (
person_id serial primary key,
);
CREATE TABLE answers (
person_id
Benjamin Arai wrote:
Has anybody had a good experience going from Npgsql to
Corelab:PostgreSQLDirect? I am considering migrating because it
offers support for COPY but I am wondering about other functionality
and performance as well. Any feedback would be greatly appreciated.
Benjamin
I continue to hope that 8.4 later (or 8.3 patched) will provide behavior
/ compatibility controls..
I personally have requested others in past, but one outstanding one now,
seems to be an ability to turn back-on implicit type conversion. I'm
struggling to see Mysql, Mssql, Oracle, and others
[Way behind on reading stuff - so I hope this wasn't covered later]
On Tue, 12 Feb 2008, Tom Lane wrote:
Ken Johanson [EMAIL PROTECTED] writes:
For sake of interoperability (and using an API that requires String-type
hashtable keys), I'm trying to find a single CAST (int - var/char)
Ken Johanson [EMAIL PROTECTED] writes:
For case 1, regarding type safety: we know use of LIKE (and SUBSTR)
requires *implicit or explicit* conversion to a text type. Why require
that explicitly?
Because it's way too easy to burn yourself with implicit conversions.
Cases comparable to the one
On Thu, 2008-02-14 at 15:55 -0700, Ken Johanson wrote:
Granted, some of the other databases have bugs in their CAST
implementations (see http://bugs.mysql.com/bug.php?id=34562
http://bugs.mysql.com/bug.php?id=34564) bugs which makes writing PG
8.3 portable code arduous or impossible
Thanks. Comments below. (PS: I am still unable to connect to
postgresql even in SSH! I see this message:
psql: could not connect to server: Connection timed out
Is the server running on host localhost and accepting
TCP/IP connections on port 5432?
Yes of course the
Magnus Hagander wrote:
I would guess they're referring to the ability to pin a table into
memory, so that it always stays in the cache regardless of what else the
database is doing. There is a narrow use-case where this can be very
useful, but it can also be a very dangerous tool (hint: if you
Stephen Cook wrote:
Magnus Hagander wrote:
I would guess they're referring to the ability to pin a table into
memory, so that it always stays in the cache regardless of what else
the database is doing. There is a narrow use-case where this can be
very useful, but it can also be a very
I don't see any strange thing.
There has been no mapping from UTF-8 0xc2a0 to SJIS in PostgreSQL
since the day one. That means, you should get the error on 7.4.3, as
well as on 8.3. Are you sure that you don't have the error on 7.4.3?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
SHIFT_JIS_2004 is
Be aware that when 8.2.3 was released, 8.2 had only been out for two
months. There's another 11 months worth of accumulated bug fixes in
8.2.6, including some that can cause the server to slow or crash. It's
not a difficult upgrade (no changes to the database) and you should
Erik Jones wrote:
See how postgres handles filling the NULLs for you? What you'd really
want to do with this would be to define some functions for setting and
getting a person's answers to a given question or set of questions so
that you could implement some kind of data integrity with
Can send email from stored procedure in Postgres?
On Fri, 15 Feb 2008 11:59:19 +0800
hewei [EMAIL PROTECTED] wrote:
Can send email from stored procedure in Postgres?
Sure, see plperl.
Joshua D. Drake
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
==in TTY1==
--11. expect result at last, value 2 only. (concurrent transaction
2 (in TTY3) completes after this, and will delete values 2 and 4
(added after select was issued) upon commit)
--11. true result: ERROR: relation large nr deleted while still in
use
The
Joshua D. Drake wrote:
On Fri, 15 Feb 2008 11:59:19 +0800
hewei [EMAIL PROTECTED] wrote:
Can send email from stored procedure in Postgres?
Sure, see plperl.
There was also this:
http://sourceforge.net/projects/pgmail/
but no idea whether it's being maintained.
--
Postgresql php
Jeff Davis [EMAIL PROTECTED] writes:
Are you saying we make special cases for all of the obvious functions,
and they should behave differently from user-defined functions?
It's possible to special-case any particular function you really feel
you need this behavior for. We did special-case ||
Hello pgsql-general,
Can send email from stored procedure in Postgres ?
Best regards,
william
[EMAIL PROTECTED]
2008-02-15
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
am Fri, dem 15.02.2008, um 11:39:53 +0800 mailte william folgendes:
Hello pgsql-general,
Can send email from stored procedure in Postgres ?
Of course, there are several solutions. For instance, use an untrusted
language like pl/perlU or pl/sh. Other solution:
pgmail from
68 matches
Mail list logo