Joshua D. Drake a écrit :
> On Fri, 2007-01-12 at 17:50 +0100, Stéphane Schildknecht wrote:
>
>> Dear community members,
>>
>> I'm having a quite strange behaviour while trying to drop some index.
>>
>> We have some tables with two indexes on a primary key. The first one was
>> automatically cre
Scott Marlowe a écrit :
> Being quite familiar with both of those issues from the past, I can't
> imagine either one causing a problem with an update prior to dumping so
> he can then upgrade to 8.2.
>
> Seriously. Hungarian collation, plerl can no longer change locale and
> corrupt indexes, and a
Hi Shoaib
Following is the output for ps auxwww | grep ^postgres
IP address of my server is 172.18.5.155
postgres 9635 0.0 0.4 44436 2420 pts/1S
Jan11 0:04 /usr/local/pgsql/bin/postgres -D
/usr/local/pgsql/data
postgres 9636 0.0 0.2 7856 1368 ?Ss
Jan11 0:00 postgres
thanks for the advice, i would buy the support from sun but I don't
think they would support version 8.2 of postgresql. i've been able to
find some sample smf files for postgresql on solaris which should
help.
On 1/13/07, Jaime Casanova <[EMAIL PROTECTED]> wrote:
On 1/12/07, Gene <[EMAIL PROTECT
On 1/12/07, Gene <[EMAIL PROTECTED]> wrote:
I've searched google and did not find any tutorials on installing
postgresql 8.2 on solaris 10. I would like to test performance of
solaris vs. linux which I'm much more familiar with. the gentoo ebuild
and fedora rpm do things like create startup scrip
Gene wrote:
> I've searched google and did not find any tutorials on installing
> postgresql 8.2 on solaris 10. I would like to test performance of
> solaris vs. linux which I'm much more familiar with. the gentoo ebuild
> and fedora rpm do things like create startup scripts / users etc.
>
> Is th
I've searched google and did not find any tutorials on installing
postgresql 8.2 on solaris 10. I would like to test performance of
solaris vs. linux which I'm much more familiar with. the gentoo ebuild
and fedora rpm do things like create startup scripts / users etc.
Is there a prebuilt package
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> Rob Tanner wrote:
>> ... I normally live in a MySql world and the first thing I do after
>> installing the DBMS is set the "root" or superuser password. The PDF
>> documentation talks about the superuser and database owner(s). How do I
>> define th
Being quite familiar with both of those issues from the past, I can't
imagine either one causing a problem with an update prior to dumping so
he can then upgrade to 8.2.
Seriously. Hungarian collation, plerl can no longer change locale and
corrupt indexes, and a minor security update.
And none
On Fri, 2007-01-12 at 16:02 -0800, Benjamin Arai wrote:
>
> psql:outfile:151275: ERROR: invalid byte sequence for encoding
> "UTF8": 0x92
>
> Does anybody know what I can do to fix this?
Here is a copy-paste from 8.1 release notes:
===
Hi,
I am trying to backup an installation (8.0.3) and restore it to a new
(8.2.1) installation. I am am running the following command the backup
the data.
pg_dumpall > outfile
Then on the new machine I am simply running:
ENCODING=UTF8 psql -f outfile postgres
I get the following error for som
On Fri, 2007-01-12 at 19:33 -0300, Alvaro Herrera wrote:
> > Alvaro, have you completed your design?
>
> No, I haven't, and the part that's missing is precisely the queues
> stuff. I think I've been delaying posting it for too long, and that is
> harmful because it makes other people waste time
Rob Tanner wrote:
> Hi,
>
> I've compiled and installed v8.2.1 to use in conjunction with the Xythos
> document management system. My problem is getting from home to first
> base. I normally live in a MySql world and the first thing I do after
> installing the DBMS is set the "root" or superuser
Hi,
I've compiled and installed v8.2.1 to use in conjunction with the Xythos
document management system. My problem is getting from home to first
base. I normally live in a MySql world and the first thing I do after
installing the DBMS is set the "root" or superuser password. The PDF
documentat
Simon Riggs wrote:
> Some feedback from initial testing is that 2 queues probably isn't
> enough. If you have tables with 100s of blocks and tables with millions
> of blocks, the tables in the mid-range still lose out. So I'm thinking
> that a design with 3 queues based upon size ranges, plus the
On mið, 2007-01-10 at 17:38 -0800, Mike Poe wrote:
> I'm a rank newbie to Postgres & am having a hard time getting my arms
> around this.
>
> I'm trying to construct a query to be run in a PHP script. I have an
> HTML form were someone can enter either a last name or a social
> security number &
On Fri, 2006-12-29 at 20:25 -0300, Alvaro Herrera wrote:
> Christopher Browne wrote:
>
> > Seems to me that you could get ~80% of the way by having the simplest
> > "2 queue" implementation, where tables with size < some threshold get
> > thrown at the "little table" queue, and tables above that s
On Fri, Jan 12, 2007 at 10:16:22PM +0100, Ji?í N?mec wrote:
> Hello,
>
> I would like to remove diacritical marks from a string in a SQL query.
> I tried to convert a UTF8 string to ASCII but it doesn't work for me.
>
> SELECT convert('?ýáíé','UTF8','SQL_ASCII')
I don't think postgres has an
Hello,
I would like to remove diacritical marks from a string in a SQL query.
I tried to convert a UTF8 string to ASCII but it doesn't work for me.
SELECT convert('ěščřžýáíé','UTF8','SQL_ASCII')
array(1) {
["convert"]=>
string(18) "ěščřžýáíé"
}
Thanks for any advice,
J.N.
---
Read the release notes. 7.4.8 and 7.4.11 require special considerations. By
all means upgrade, but it's not quite seamless.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Marlowe
Sent: Friday, January 12,
Alvaro Herrera wrote:
> Bruce Momjian wrote:
>
> > Here the column result is an expression, and you reference that.
> > Updated wording:
> >
> > test=> select * from test union select * from test order by x is null;
> > ERROR: A UNION/INTERSECT/EXCEPT ORDER BY cannot use expressions or
> > f
Right, but I assumed you checked with HP before coming here. I should
have said "for PG 8.2.1 on HP-UX, you will need to build from source".
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: Al Balmer [mailto:[EMAIL PROTECTED]
Sent: Friday, January 12, 2007 12:39 PM
To: B
Scott Ribe <[EMAIL PROTECTED]> writes:
> Note when it happens, and if it doesn't succeed for some value of "too
> long", at least escalate to ERROR message, possibly fail.
ERROR and "fail" are the same thing. We could do this, and it wouldn't
even be much code, but it doesn't seem to address the
On Fri, 2007-01-12 at 10:50, Stéphane Schildknecht wrote:
> Dear community members,
>
> I'm having a quite strange behaviour while trying to drop some index.
>
> We have some tables with two indexes on a primary key. The first one was
> automatically created by the primary constraint. The second
> Comments?
Note when it happens, and if it doesn't succeed for some value of "too
long", at least escalate to ERROR message, possibly fail.
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 722-0567 voice
---(end of broadcast)--
On Fri, 2007-01-12 at 17:50 +0100, Stéphane Schildknecht wrote:
> Dear community members,
>
> I'm having a quite strange behaviour while trying to drop some index.
>
> We have some tables with two indexes on a primary key. The first one was
> automatically created by the primary constraint. The s
AFAIK, PostgreSQL is only supplied in Win32 and Fedora/Redhat flavors.
Debian, Gentoo, and FreeBSD maintain their own binary packages
themselves.
For HP-UX, you need to build from source.
http://www.postgresql.org/docs/faqs.FAQ_HPUX.html
--
Brandon Aiken
CS/IT Systems Engineer
-Original Mes
Magnus Hagander <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> pg_control is certainly not ever deleted or renamed, and in fact I
>> believe there's an LWLock enforcing that only one PG process at a time
>> is even touching it. So we need another theory to explain this one :-(
> Right. What we
Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
>> Tom Lane wrote:
>>> Actually, it could still be the same problem, with the AV software only
>>> involved to the extent that it's trying to scan files for viruses.
>
>> Partially the same, but I've seen AV software keeping it open for
Dear community members,
I'm having a quite strange behaviour while trying to drop some index.
We have some tables with two indexes on a primary key. The first one was
automatically created by the primary constraint. The second one was
manually created on the same column. Don't know why, but I wou
Magnus Hagander <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Actually, it could still be the same problem, with the AV software only
>> involved to the extent that it's trying to scan files for viruses.
> Partially the same, but I've seen AV software keeping it open for
> hours... Basically un
Does anyone know where to get postgreSQL 8.2 binaries or depot for
HP-UX? We have a problem because of non-conforming backslash handling,
and I understand that's been fixed in 8.2.
--
Al Balmer
Sun City, AZ
---(end of broadcast)---
TIP 4: Have you
Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
>> On Fri, Jan 12, 2007 at 09:47:55AM -0500, Tom Lane wrote:
>>> No, I didn't claim that Windows AV software is bug-free ;-). What I
>>> said was that I'm not certain it's related to the "permission denied"
>>> reports, as opposed to ot
Evgeny Gridasov wrote:
> Hello.
>
> So, what happens if I set checkpoint_segments and checkpoint_timeout very
> high,
> and, shared_buffers to a very low value?
> Will PostgreSQL force a checkpoint when it has not enough memory in
> shared_buffers for some new "un-checkpointed" data ?
It won't
Hello.
So, what happens if I set checkpoint_segments and checkpoint_timeout very high,
and, shared_buffers to a very low value?
Will PostgreSQL force a checkpoint when it has not enough memory in
shared_buffers for some new "un-checkpointed" data ?
On Fri, 12 Jan 2007 10:49:04 -0300
Alvaro Herre
Thanks for the reply, Tom. Yes, I had copied some data from a VIEW into a
TABLE (named temp_measurement), then deleted the VIEW and renamed the
TABLE, but must've created my script before performing the rename...
And, yes, it was a Data-only restore.
So, after recreating my scripts and creating
Magnus Hagander <[EMAIL PROTECTED]> writes:
> On Fri, Jan 12, 2007 at 09:47:55AM -0500, Tom Lane wrote:
>> No, I didn't claim that Windows AV software is bug-free ;-). What I
>> said was that I'm not certain it's related to the "permission denied"
>> reports, as opposed to other problems. Or are
Tom Lane <[EMAIL PROTECTED]> wrote:
Well, if the problem is indeed in pg_statistic, it'll be easy to repair
(think TRUNCATE...). Have you turned up the logging level to find out?
BTW, please don't do anything to try to correct the problem until we're
pretty sure we understand how this happened
On Fri, Jan 12, 2007 at 09:47:55AM -0500, Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
> > On Thu, Jan 11, 2007 at 10:39:47PM -0500, Tom Lane wrote:
> >> One point worth making is that I'm not really convinced anymore that
> >> we have proof that antivirus code has been creating an
Gellert, Andre wrote:
Hello Richard,
We have such a testsystem now, 4 x AMD Opteron (double core techn.)
885 2.6ghz , running with 32 GB Ram and fast 10.000rpm SAS discs,
How many disks? What RAID?
4 Disks, RAID1.
Is your disk I/O saturating? Try vmstat/iostat (or whatever the Solaris
equ
Jeff Amiel <[EMAIL PROTECTED]> writes:
> Any ideas on how should I move forward?
Well, if the problem is indeed in pg_statistic, it'll be easy to repair
(think TRUNCATE...). Have you turned up the logging level to find out?
BTW, please don't do anything to try to correct the problem until we're
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Hmm, as far as I can tell, the database entry would not be created
> merely by a vacuum. The only way to create a database entry in pgstat
> is by calling pgstat_recv_tabstat(); and pgstat_report_tabstat is only
> called in postgres.c (not invoked via a
Magnus Hagander <[EMAIL PROTECTED]> writes:
> On Thu, Jan 11, 2007 at 10:39:47PM -0500, Tom Lane wrote:
>> One point worth making is that I'm not really convinced anymore that
>> we have proof that antivirus code has been creating any such problems.
> We do. I have positive proof of this being cau
Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > Hmm, that would mean an ANALYZE got done on template0, no? ... but
> > AFAICT process_whole_db() always sets analyze=false.
>
> The thing that's bothering me is that I don't see any certainty that
> template0 is only processed via th
"Zeugswetter Andreas ADI SD" <[EMAIL PROTECTED]> writes:
> It seems the win unlink is not implemented correctly and we need to
> replace it.
Easier said than done ...
regards, tom lane
---(end of broadcast)---
TIP 9: In vers
On Thu, Jan 11, 2007 at 10:39:47PM -0500, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > On Thu, Jan 11, 2007 at 03:14:37PM -0500, Tom Lane wrote:
> >> ... And anyway there should never
> >> *be* a real permissions problem; if there is then the user's been poking
> >> under the ho
On Fri, Jan 12, 2007 at 10:49:53AM +0100, Zeugswetter Andreas ADI SD wrote:
>
> > > I find it very unlikely that you would "during normal operations"
> end up
> > > in a situation where you would first have permissions to create
> files in
> > > a directory, and then lose them.
> > > What could be
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Hmm, that would mean an ANALYZE got done on template0, no? ... but
> AFAICT process_whole_db() always sets analyze=false.
The thing that's bothering me is that I don't see any certainty that
template0 is only processed via the process_whole_db() path.
Tom Lane wrote:
> Jeff Amiel <[EMAIL PROTECTED]> writes:
> > We've downloaded/compiled pg_filedump, but are stumped as to what relation
> > (or even what database) to start with.
>
> Turn up log_min_messages to DEBUG2 and you'll be able to see which
> table autovac is failing at. If I had to bet
Ashish Karalkar wrote:
> Hello all,
> I am getting a syntax error near open cursor,
> can anybody please point me what is missing. i am
> using Postgresql 8.2
>
> CREATE OR REPLACE FUNCTION
> sp_gen_foreign_keys_tables(OUT par_result integer, OUT
> par_childtables text, IN par_colname character va
Evgeny Gridasov wrote:
> Hello.
>
> Lets's imagine a sequence in time:
> (1) Some transactions commit data (simple table inserts/updates).
> (2) I get data from a table using select.
> (3) A CHECKPOINT occurs, data from pg_xlog is copied to actual table data
> files.
>
> Questions:
>
> Where do
Alvaro Herrera <[EMAIL PROTECTED]> wrote:
Did you perchance connect to template0 (probably marking it as
connectable in the process), made some modification there, and then
mark it as non-connectable again, without executing VACUUM FREEZE on it?
AFAICS we only execute VACUUM FREEZE on it, so we s
Hello.
Lets's imagine a sequence in time:
(1) Some transactions commit data (simple table inserts/updates).
(2) I get data from a table using select.
(3) A CHECKPOINT occurs, data from pg_xlog is copied to actual table data files.
Questions:
Where does PostgreSQL read data during (2) process?
Fo
Hello all,
I am getting a syntax error near open cursor,
can anybody please point me what is missing. i am
using Postgresql 8.2
CREATE OR REPLACE FUNCTION
sp_gen_foreign_keys_tables(OUT par_result integer, OUT
par_childtables text, IN par_colname character varying
, IN par_colvalue integer) AS
$BO
Hello Richard,
> > We have such a testsystem now, 4 x AMD Opteron (double core techn.)
> > 885 2.6ghz , running with 32 GB Ram and fast 10.000rpm SAS discs,
>
> How many disks? What RAID?
4 Disks, RAID1.
> Is your disk I/O saturating? Try vmstat/iostat (or whatever the Solaris
> equivalent i
Jeff Amiel wrote:
> Sure enough I did make autovacuum more agressive about 30-45 days ago (have
> to check the logs to find the exact date). Was originally whatever default
> settings that came out of the box with 8.1. Naptime is currently set to 60
> seconds.
>
> Am I to assume that this
Artis Caune wrote:
Thanks a lot!
Normal upper/lower loop works fine:
CREATE OR REPLACE FUNCTION add_user( VARCHAR(128)[] ) RETURNS SMALLINT
I'd rename the function "add_users()"
AS $$
DECLARE
v_uid SMALLINT;
v_low SMALLINT;
v_upp SMALLINT;
empty BOOLEAN := TRUE;
BEGIN
SELECT INTO
Tom Lane <[EMAIL PROTECTED]> wrote:So apparently there's some row in template0
that didn't get marked
committed before the pg_clog segment for it went away. Given 8.1's
rather schizophrenic view of whether it can modify template0 or not,
this is not too surprising, but I thought we'd put in some
Thanks a lot!
Normal upper/lower loop works fine:
CREATE OR REPLACE FUNCTION add_user( VARCHAR(128)[] ) RETURNS SMALLINT AS $$
DECLARE
v_uid SMALLINT;
v_low SMALLINT;
v_upp SMALLINT;
empty BOOLEAN := TRUE;
BEGIN
SELECT INTO v_low array_lower($1,1);
SELECT INTO v_upp array_upper($1,1)
On Fri, Jan 12, 2007 at 11:50:19AM +0100, Albe Laurenz wrote:
> > gmake[3]: Entering directory
> `/home/km/postgresql8.2.1/postgresql-8.2.1/src/pl/plpython'
> > gcc -fPIC -Wall -Wmissing-prototypes -Wpointer-arith -Winline
> -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -g
> -fp
On Thursday 11 January 2007 15:03, Adam Rich wrote:
> How about this?
>
> select item, very_expensive_function(item) as exp, cheap
> from ( Select item, cheap_function(item) as cheap
> From atable where cheap_function(item) > 0 ) sub
> where very_expensive_function(item) > 0
>
>
Well, there i
On Thursday 11 January 2007 15:12, Alban Hertroys wrote:
> Maybe your functions can be marked STABLE or even IMMUTABLE? That should
> help the planner evaluate them less often.
They are immutable, nevertheless they will have to be computed for each
record. I'd just like to have some influence on
Gellert, Andre wrote:
Hello all,
I need some hints how to setup Postgresql on a brand new testsystem.
Due to heavy load on the current database servers, my boss decided to
test a big server as a replacement for 5 other servers. ;-) The
system is used in a extranet environment - over 50 percen
Hello all,
I need some hints how to setup Postgresql on a brand new testsystem.
Due to heavy load on the current database servers, my boss decided to test a
big server as a replacement for 5 other servers. ;-) The system is used in a
extranet environment - over 50 percent of the load is prod
Artis Caune wrote:
I'm trying to write function which accept array and insert each element
in table:
=# SELECT * FROM add_user('[EMAIL PROTECTED], [EMAIL PROTECTED]');
ERROR: column "email" is of type character varying but expression is
of type record
HINT: You will need t
> > I find it very unlikely that you would "during normal operations"
end up
> > in a situation where you would first have permissions to create
files in
> > a directory, and then lose them.
> > What could be is that you have a directory where you never had
> > permissions to create the file in th
I'm trying to write function which accept array and insert each element
in table:
=# SELECT * FROM add_user('[EMAIL PROTECTED], [EMAIL PROTECTED]');
ERROR: column "email" is of type character varying but expression is
of type record
HINT: You will need to rewrite or cast th
67 matches
Mail list logo
