On 07/06/10 08:34, Zery wrote:
All,
I'm a newbie in postgresql, a few days ago i install postgresql
8.4.3.1 and it works fine, yesterday i install cyberlink powerdvd 9
and after that my postgresql server cannot start, it give the
following error info :
The postgresql-8.4 - PostgreSQL
On 07/06/10 10:29, John T. Dow wrote:
One of my clients is getting this problem occasionally. Actually, we
can cause it to happen quite reliably by pasting certain text into a
couple of fields, but the vast majority of text entered into the vast
majority of fields causes no problem.
I've
Hi all -
I have an existing table that looks like this:
CREATE TABLE orders
(
--Bunch of stuff you don't care about
orderstate integer NOT NULL,
--Etc
)
with a bunch of data in it. I've now created this new data type:
CREATE TYPE OrderStateEnum AS ENUM ('Preview', 'InQueue', 'Ordered',
Ok, I'm convinced this should work but it does not:
CREATE FUNCTION ConvertIntToOrderStateEnum(state integer) RETURNS
OrderStateEnum AS
$BODY$
SELECT CASE WHEN $1=0 then 'Preview'::OrderStateEnum
WHEN $1=1 then 'InQueue'::OrderStateEnum
WHEN $1=2 then 'Ordered'::OrderStateEnum
WHEN $1=3
Doh! I suck, I had a CHECK constraint on that column to make sure the
value was between 0 and 4 (the whole reason I was switching to an
enum). Once I dropped the constraint, the ALTER TABLE worked
perfectly.
I guess I have to gripe about the error message though, it should tell
me there was a
Craig,
Nothing is usefull or barely i understand :-)
In pg_log i only find this :
2010-06-07 14:11:40 ICT LOG: could not receive data from client: An
operation was attempted on something that is not a socket.
2010-06-07 14:11:40 ICT LOG: incomplete startup packet
In event viewer i found :
Eliot Gable egable+pgsql-gene...@gmail.com writes:
I have a set of results that I am selecting from a set of tables which I want
to return in a random weighted order for each priority group returned. Each
row has a
priority column and a weight column. I sort by the priority column with 1
Hi List,
I am trying to execute a function which returns a refcursor, from ODBC client,
But ODBC client could not able to recognize the refcursor hence could not able
to retrieve the resultset.
I am working with Posgresql 8.4 version.
Do ODBC - Posgresql supports refcursor?
Do we have user
Hi ,
The installer has an error dealing with directory separator char on windows
platform, it seems the installer causes the server looking for configuration
file path with /, it should be \. Hoping Enterprisedb engineers can see
this message.
On Mon, Jun 7, 2010 at 11:24 AM, Amber guxiaobo1...@gmail.com wrote:
Hi ,
The installer has an error dealing with directory separator char on windows
platform, it seems the installer causes the server looking for configuration
file path with /, it should be \. Hoping Enterprisedb engineers
Hi.
At an environment(Ver8.4.2),a simmilar error happened and we could work
around
setting postgresql.conf
client_min_messages = log
to
client_min_messages = notice .
I'm not sure that your error is same,
but can you try this?
//Your message is following
//2010-06-07 14:11:40 ICT LOG:
This is probably not the right forum for this question, but maybe
someone can help me out or redirect me.
I'm running into a lot of problems with npgsql and enum types. There
seems to be very little support or testing in this area. The issue
right now is I have a lot of SQL functions that have
Eliot Gable wrote:
rows. Basically, I thought that if the original data was:
50, 1, 5, 'data1'
55, 1, 4, 'data2'
34, 2, 0, 'data3'
90, 2, 1, 'data4'
95, 2, 1, 'data5
And the input to the functions was:
50, 1, 5
55, 1, 4
34, 2, 0
90, 2, 1
95, 2, 1
And the prioritized and weighted order came
When running the installer, there is a warning,
Problem running post-install step. Installation may not complete correctly
Error reading file
D:/amber/program/postgresql/8.4/data/postgres.conf
When start the service, the following entry is written in windows event log
Ashesh,
Can you take a look at this please? I wonder is there's an issue with
the data directory being on the D drive.
Thanks.
On Mon, Jun 7, 2010 at 11:41 AM, Amber guxiaobo1...@gmail.com wrote:
When running the installer, there is a warning,
Problem running post-install step. Installation
Hi Dave
I am not sure whether you have received my message, sorry for duplicate
messages.
Xiaobo gu
From: Amber [mailto:guxiaobo1...@gmail.com]
Sent: Monday, June 07, 2010 6:42 PM
To: Dave Page
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Error in 8.4.4-1 of windows
Hi Ashesh,
No, it’s a physical partition.
Amber
From: Ashesh Vashi [mailto:ashesh.va...@enterprisedb.com]
Sent: Monday, June 07, 2010 8:15 PM
To: Dave Page
Cc: Amber; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Error in 8.4.4-1 of windows installer from Enterprisedb
Hi
No one has had this problem??? Should I perhaps direct this to the developers
list?
Cheers,
Max
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Max Williams
Sent: 03 June 2010 14:22
To: pgsql-general@postgresql.org
Subject: [GENERAL] Performance
Hi Amber,
Can you please share the installation log file with us found under %TEMP%
directory?
--
Thanks Regards,
Ashesh Vashi
EnterpriseDB INDIA: Enterprise Postgres Companyhttp://www.enterprisedb.com
On Mon, Jun 7, 2010 at 6:01 PM, 顾小波 guxiaobo1...@gmail.com wrote:
Hi Ashesh,
No,
On Fri, Jun 04, 2010 at 10:51:27AM -0500, erobles wrote:
Hello! I have postgres running on SCO OpenServer 5.0.7
and I've noticed that only accepts up to 94 connections, no more ...
I modified the values in postgresql.conf
max_connections from 100 to 128
shared_buffers from 24 to 48 MB
On Fri, 2010-05-28 at 09:44 +0100, Piotr Kublicki wrote:
What's wrong with it?
Package layouts changed since it was written... I will update it before
9.0.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community:
On Mon, Jun 7, 2010 at 08:44, Craig Ringer cr...@postnewspapers.com.au wrote:
On 07/06/10 10:29, John T. Dow wrote:
One of my clients is getting this problem occasionally. Actually, we
can cause it to happen quite reliably by pasting certain text into a
couple of fields, but the vast majority
Magnus Hagander, 07.06.2010 15:52:
Some AV software probably behaves fine.
Probably.
In case anyone is interested:
I have two development computers that run Postgres on Windows XP.
One with Avira the other with Sophos.
Neither has or had any problems installing or running Postgres
Regards
On Mon, Jun 7, 2010 at 15:58, Thomas Kellerer spam_ea...@gmx.net wrote:
Magnus Hagander, 07.06.2010 15:52:
Some AV software probably behaves fine.
Probably.
In case anyone is interested:
I have two development computers that run Postgres on Windows XP.
One with Avira the other with
Magnus Hagander, 07.06.2010 16:15:
On Mon, Jun 7, 2010 at 15:58, Thomas Kellererspam_ea...@gmx.net wrote:
Magnus Hagander, 07.06.2010 15:52:
Some AV software probably behaves fine.
Probably.
In case anyone is interested:
I have two development computers that run Postgres on Windows XP.
On 06/07/2010 07:44 AM, Joshua Tolley wrote:
What does it say when it refuses connections above 94? Also, when you
connect:
This is the message:
LOG: could not fork new process fro connection: Resource temporarily
unavailable...
and those are the kernel's resources values:
NODE
dm.a...@gmail.com (DM) writes:
It is not real time, updates every 5 mins should be fine.
But the DB2 database is real busy and its real performance based.
The book Scalable Internet Architectures (by Theo Schlossnagle) has
an example of how to build a trigger-based replication system copying
gareth.willi...@csiro.au wrote:
Re-reading the documentation
http://www.postgresql.org/docs/8.4/interactive/sql-reindex.html it is clear now
that reindex or recreating and index should not normally be needed - certainly
not to keep an index up-to-date. I would have guessed that VACUUM or
Max Williams wrote:
No one has had this problem??? Should I perhaps direct this to the
developers list?
pgsql-performance is the list you should have sent this to. There are
several people who are subscribed to that one but not to -general or
-hackers who enjoy helping with this
Hi,
Maybe this is better asked on -general instead of -testers.
First off, thank you for bringing this into contrib.
I built beta2 this morning to give pg_upgrade a test run, and everything
worked out great. The only thing I am not sure of is the expected
location of pg_upgrade_support.so.
On Sat, Jun 5, 2010 at 11:38 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Sat, Jun 5, 2010 at 5:27 PM, u235sentinel u235senti...@gmail.com wrote:
I'm curious if anyone has had any experiences (good and bad) using Postgres
on Dell PowerEdge servers.
I've had lots of experience with
On Sun, Jun 6, 2010 at 5:29 PM, Wang, Mary Y mary.y.w...@boeing.com wrote:
I'm using a psql -f command to reload the data from a dump file. I noticed
that some tables are not populated with any rows (I mean 0 rows), yet, if I
manually insert a row (actually just copy an INSERT statement from
On 6/7/10 1:14 PM, Glen Barber wrote:
[snip]
Is this module ending up in the wrong location on install, or is
pg_upgrade looking in the wrong place?
I've received a reply on -testers about this, in case anyone is using
pg_upgrade with testing 9.0.
Excerpts from Greg Smith's message of lun jun 07 12:23:44 -0400 2010:
It is a periodic preventative maintenance operation you can expect to
need occasionally, but certainly not often. Indexes maintain themselves
just fine most of the time. They can get out of whack if you delete a
lot of
That's good to know. I ended up manually copy/paste INSERT statements for each
table to another file and rerun the psql -f again. It was painful!
Mary
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Vick Khera
Glen Barber wrote:
Hi,
Maybe this is better asked on -general instead of -testers.
First off, thank you for bringing this into contrib.
I built beta2 this morning to give pg_upgrade a test run, and everything
worked out great. The only thing I am not sure of is the expected
location
On 06/07/2010 02:10 PM, Wang, Mary Y wrote:
That's good to know. I ended up manually copy/paste INSERT statements for each
table to another file and rerun the psql -f again. It was painful!
Mary
For future reference you could do something like:
pg_dump -a -t table_name -f
Hi Bruce,
On 6/7/10 5:12 PM, Bruce Momjian wrote:
Glen Barber wrote:
Hi,
Maybe this is better asked on -general instead of -testers.
First off, thank you for bringing this into contrib.
I built beta2 this morning to give pg_upgrade a test run, and everything
worked out great. The only
Glen Barber wrote:
exception of --prefix=/usr/local/pgsql-beta2; pg_upgrade_support.so
ended up in /usr/local/pgsql-beta2/lib.
Here is what I saw when running pg_upgrade initially:
%pg_upgrade -d /var/db/pgsql/data \
-D /var/db/pgsql/data2 \
-b /usr/local/pgsql-beta1/bin \
On 6/7/10 6:59 PM, Bruce Momjian wrote:
Glen Barber wrote:
exception of --prefix=/usr/local/pgsql-beta2; pg_upgrade_support.so
ended up in /usr/local/pgsql-beta2/lib.
Here is what I saw when running pg_upgrade initially:
%pg_upgrade -d /var/db/pgsql/data \
-D /var/db/pgsql/data2 \
-b
Great suggestion. Thanks. Don't know why I didn't think of that. I do almost
exactly the same thing further down in my stored procedure.
On Mon, Jun 7, 2010 at 4:34 AM, Dimitri Fontaine dfonta...@hi-media.comwrote:
Eliot Gable egable+pgsql-gene...@gmail.comegable%2bpgsql-gene...@gmail.com
On 6/7/10 7:48 PM, Glen Barber wrote:
[snip]
Interestingly, I apparently would have had this issue with beta1:
%pwd
/usr/local/pgsql-beta1/bin
%./pg_config --pkglibdir
/usr/local/pgsql-beta1/lib/postgresql
%cd ../../pgsql-beta2/bin/
%./pg_config --pkglibdir
Glen Barber wrote:
On 6/7/10 7:48 PM, Glen Barber wrote:
[snip]
Interestingly, I apparently would have had this issue with beta1:
%pwd
/usr/local/pgsql-beta1/bin
%./pg_config --pkglibdir
/usr/local/pgsql-beta1/lib/postgresql
%cd ../../pgsql-beta2/bin/
%./pg_config --pkglibdir
OP here
We removed AVG from the computer and rebooted.
Same problem.
We are quite certain that AVG is no longer installed. It doesn't show up where
it used to, and a search of the registry for AVG finds a couple leftovers but
doesn't seem to indicate that it's still installed.
The
Thank you all,
It works now using Craig Winsock solution.
Before that i use Ken client_min_messages solution, but it doesn't solve it.
I'll check back if this permanent fixed or just temporary.
BR,
Zery
On 6/7/10, Kenichiro Tanaka ketan...@ashisuto.co.jp wrote:
Hi.
At an
On 06/07/2010 12:13 PM, Vick Khera wrote:
Ditto. Of late I'm buying HPs, but I haven't yet put one into
database service. Our DB servers are all currently Sun with fibre
channel cards to external RAID systems.
What kind of external RAID systems do you connect your Sun servers to?
On 08/06/10 09:40, Zery wrote:
Thank you all,
It works now using Craig Winsock solution.
Before that i use Ken client_min_messages solution, but it doesn't solve it.
I'll check back if this permanent fixed or just temporary.
Yikes. I strongly recommend contacting PowerDVD technical
On Mon, Jun 7, 2010 at 7:43 PM, u235sentinel u235senti...@gmail.com wrote:
On 06/07/2010 12:13 PM, Vick Khera wrote:
Ditto. Of late I'm buying HPs, but I haven't yet put one into
database service. Our DB servers are all currently Sun with fibre
channel cards to external RAID systems.
Hi,
I have a question that is not specified in the docs[1]. I am using
deferrable constraints in a transaction with SET CONSTRAINTS ALL
DEFERRED. Now I know that DEFERRED constraints are not checked until
transaction COMMIT (i.e., the end), however are they checked with
SAVEPOINT (i.e., part-way
On Mon, Jun 7, 2010 at 9:43 PM, u235sentinel u235senti...@gmail.com wrote:
What kind of external RAID systems do you connect your Sun servers to? I've
talked to Oracle/Sun and haven't been able to get a solution even similar to
the 4540 systems. I'm hoping to find something that will allow a
On Sun, Jun 6, 2010 at 8:29 PM, John T. Dow j...@johntdow.com wrote:
I'd had to tell my client to purchase more hardware because the database
software I've recommended has a problem. I have a number of other clients
using Postgres and nobody else has had any problem. Switching AV software
On 8/06/2010 9:11 AM, John T. Dow wrote:
OP here
We removed AVG from the computer and rebooted.
Same problem.
OK, good to know. Thanks very much for testing that, and my apologies
for recommending something that didn't work out. Of course, it would
have been hard to progress without
On 06/07/2010 08:01 PM, Scott Marlowe wrote:
Where I work we use these:
http://www.pc-pitstop.com/sata_enclosures/scsas16rm.asp
for when we need lots of throughput (file servers). They allow four
SAS connectors instead of the typical one or two.
and will be using these:
On 06/07/2010 08:08 PM, Vick Khera wrote:
Our primary DB server is a Sun X4200 M2 with 20Gb RAM with a Dual
LSILogic FC7X04X 4Gb/s FC PCI-Express Adapter fibre channel card
plugged into it, directly connected to a SurfRAID Triton 16 array from
Partners Data Systems. The SurfRAID does the RAID
Ok I did more investigation on this and traced the issue down to a
singe npgsql bug. Enums actually work fine, as long as you're using
an IDataReader to get at the data. Once you attempt to load the
reader into a DataSet, it blows up. I'll log this bug..
Mike
On Mon, Jun 7, 2010 at 4:43 AM,
I have a column in a table that's an ENUM type. What's the best type
of index for this? It seems if I use a btree index, that's more
optimized for doing greater than or less than comparisons which don't
apply to an enum. I will only be doing equals comparisons on these
columns. Thanks!
Mike
Mike Christensen m...@kitchenpc.com writes:
I have a column in a table that's an ENUM type. What's the best type
of index for this? It seems if I use a btree index, that's more
optimized for doing greater than or less than comparisons which don't
apply to an enum. I will only be doing
Thanks, that's what I figured.
Just to double check, an enum type is gonna be stored on the disk as
an integer, correct? And all indexes will be based on the integer
value of the enum? Postgres only wants you to believe it's a string
when you look at the data.
Mike
On Mon, Jun 7, 2010 at 8:31
Mike Christensen m...@kitchenpc.com writes:
Just to double check, an enum type is gonna be stored on the disk as
an integer, correct? And all indexes will be based on the integer
value of the enum?
Well, strictly speaking it's an OID, but yeah. The label is only
of interest for I/O.
59 matches
Mail list logo