Hi again,
I've taken in all the feedback about http://forums.postgresql.com.au and the
general consensus is that nobody wants a separate entity - a few people
mentioned that if it was interoperable with the mailing list that it would be
better. So I did.
The concept goes like this;
1. Any post
I getting error in Postgresql 9.0.1.
select description ,to_tsvector(description) from crm where crmid = 1;
NOTICE: word is too long to be indexed
DETAIL: Words longer than 2047 characters are ignored.
Any idea pelase how to solve it.
On 11/09/2010 06:01 PM, Andy wrote:
MySQL is GPL'd, just like Linux is.
Well it is and it isn't. A couple of years ago when I was involved with
choosing DB for a (proprietary) application we could not figure MySQLs
license out. It was GPL'd but at the same time if you wanted to use it
commerc
Possibly someday the standard will actually standardize the things,
and then maybe we can work with them usefully ...
From http://tools.ietf.org/html/rfc4007#section-11.2
implementation SHOULD
support the following format:
%
where
is a literal IPv6 address,
is a
On 15 November 2010 08:34, Elliot Chance wrote:
> Hi again,
>
> I've taken in all the feedback about http://forums.postgresql.com.au and
> the general consensus is that nobody wants a separate entity - a few people
> mentioned that if it was interoperable with the mailing list that it would
> be
On 15/11/2010, at 8:37 PM, Thom Brown wrote:
> On 15 November 2010 08:34, Elliot Chance wrote:
> Hi again,
>
> I've taken in all the feedback about http://forums.postgresql.com.au and the
> general consensus is that nobody wants a separate entity - a few people
> mentioned that if it was inter
Hi,
I can't find pg_stat_activity in the the documentation.
There are many pg_stat_xxx tables and views, but their columns are not
described, or so it seems.
Maybe that is a bug in the documentation, then.
I was looking for what exactly "waiting" means in pg_stat_activity. In the
9.0.1 documentat
On Mon, Nov 15, 2010 at 11:08, Elliot Chance wrote:
> On 15/11/2010, at 8:37 PM, Thom Brown wrote:
>> I know this is a sensitive issue with some people, i've made sure no
>> information is posted thats not already currently being indexed by google.
>>
>> The only maintenance I can see is that all
Hello again.
Well, the data that I want to import is some satellite coordinates saved in
mysql , the fields are X and Y and want to import them into a postgis table
for converting these coordinates to a normal latitude and longitude points
because in mysql are saved in Utm format.
I have foound
Hi,
I'm experimenting with partitioning.
I have split up my original table into 15 parts and i have written a trigger
that will handle the INSERTs.
I didn't want to write the same insert statement 15 times, so i thought it
would be a good thing to just dynamically build the insert statement in the
Gabriele, Thank you for the link. I downloaded the book and read the chapter.
Very useful information.
Craig,
The storage type is SAN over AFP.
Unfortunately, it has been a week or so since the crash. We were able to
recover lost data from last backup (a few hours old) but next time, I will
Hello
2010/11/15 Willy-Bas Loos :
> Hi,
>
> I'm experimenting with partitioning.
> I have split up my original table into 15 parts and i have written a trigger
> that will handle the INSERTs.
> I didn't want to write the same insert statement 15 times, so i thought it
> would be a good thing to ju
Hi,
I need to download postgreSQL develope package for ver. 8.3.8, but I can not
find the ...i386.rpm anywhere.
Please, could someone guide me to the right place?
Kind regards,
Paul
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:
On Sun, Nov 14, 2010 at 10:34 PM, Evan D. Hoffman
wrote:
> as part of another project) running on CentOS 5.4 or 5.5. I know the
> old rule of thumb that your swap partition/disk should be equal to the
> physical memory, but when dealing with memory sizes greater than ~16
> GB that starts to seem
On Mon, Nov 15, 2010 at 5:15 AM, Willy-Bas Loos wrote:
> I was looking for what exactly "waiting" means in pg_stat_activity.
waiting for a lock.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-g
On Sun, Nov 14, 2010 at 7:44 AM, franrtorres77 wrote:
> I need to add periodically some data from a remote mysql database into our
> postgresql database. So, does anyone know how to do it having in mind that
> it must be runned every minute or so for adding new records to the
> postresql?
People
Assume I have a local process which leaves a transaction open & idle for an
extended period of time. Is there any way to identify the local process
connected to a particular backend?
pg_stat_activity is fine for TCP connections but does not provide useful
identifying information for domain sock
Scott Ribe writes:
> Assume I have a local process which leaves a transaction open & idle for an
> extended period of time. Is there any way to identify the local process
> connected to a particular backend?
netstat will probably work for this, depending on what platform you're on.
On Nov 15, 2010, at 8:50 AM, Tom Lane wrote:
> netstat will probably work for this, depending on what platform you're on.
OS X. I can see the connections, but I don't see an option to display PIDs.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
On 11/15/2010 11:00 AM, Scott Ribe wrote:
On Nov 15, 2010, at 8:50 AM, Tom Lane wrote:
netstat will probably work for this, depending on what platform you're on.
OS X. I can see the connections, but I don't see an option to display PIDs.
netstat -an will do it on linux.
sockst
Scott Ribe writes:
> On Nov 15, 2010, at 8:50 AM, Tom Lane wrote:
>> netstat will probably work for this, depending on what platform you're on.
> OS X. I can see the connections, but I don't see an option to display PIDs.
In that case see lsof --- you can match up the ends of the connection
usin
On Nov 15, 2010, at 9:24 AM, Tom Lane wrote:
> In that case see lsof --- you can match up the ends of the connection
> using the hex value in the "device" column.
>
> regards, tom lane
>
Yes, that works. Match "Address" from netstat to "DEVICE" in lsof.
Thanks.
--
Sco
On Nov 15, 2010, at 9:05 AM, Steve Clark wrote:
> netstat -an will do it on linux.
>
> sockstat will do it on FreeBSD.
>
> What's OS X ? ;-)
Apple must use very different option switches for their netstat, because I see
no way to get PIDs (which seems like a pretty big oversight to me), and -
Hello,
I need to access a database using two different schemas. During initialization
the default schema is set as follows:
set schema 'ucm';
Then later, I need to get data from a table in another schema
'ts_sofia_internal', so I tried the following, but it returns an error as shown:
teo=# s
On Mon, Nov 15, 2010 at 8:35 AM, Jerry Richards
wrote:
>
> teo=# select * from sip_presence('ts_sofia_internal') where
> sip_presence.sip_user='1003';
>
> ERROR: function sip_presence(unknown) does not exist
>
> LINE 1: select * from sip_presence('ts_sofia_internal') where sip_pr...
>
Le lundi 15 novembre 2010 à 08:17 +0100, Alban Hertroys a écrit :
> >
> > I have only used MS Access (for years). My difficulties are very basic.
> > When I said I can't view the data in the data base, I meant basically - with
> > any method. The psql help shows many ommands for displaying. My
bricklen writes:
> On Mon, Nov 15, 2010 at 8:35 AM, Jerry Richards
> wrote:
>>
>> teo=# select * from sip_presence('ts_sofia_internal') where
>> sip_presence.sip_user='1003';
>>
>> ERROR:Â function sip_presence(unknown) does not exist
> The problem isn't the schema name, it is with the parame
The standby log:
-> 2010-11-14 17:40:16 MST - 887 -LOG: database system was shut down in
recovery at 2010-11-14 17:40:10 MST
-> 2010-11-14 17:40:16 MST - 887 -LOG: entering standby mode
-> 2010-11-14 17:40:16 MST - 887 -LOG: consistent recovery state reached at
3/3988FF8
-> 2010-11-14 17:
Thanks for all your valuable thoughts . It took me a while to read all your
suggestions , still trying to understand it fully.
What we do with the text that I have mentioned is, we have
search functionality on the text. The user enters some keywords and then the
application should be able to searc
On Mon, Nov 15, 2010 at 2:53 PM, Malm Paul wrote:
>I need to download postgreSQL develope package for ver. 8.3.8
Why 8.3.8?
8.3.10 is the same, only with issues fixed.
http://www.postgresql.org/ftp/binary/v8.3.10/linux/rpms/
hth
WBL
--
"Patriotism is the conviction that your country is superior
Hi there,
I'm wondering if I'm seeing the appropriate amount of vacuuming in my
8.4 database.
I have a database with about twenty tables ranging from small, mostly
static, tables to tables with tens or hundreds of thousands of rows and
a fair number of inserts and updates (but very few delet
Thanks, each of you for all the suggestions on schema generating tools. The
idea is to have something which will connect to the database and automatically
make a schema from what you've got. Here's what I have had a chance to
evaluate so far...
DBVisualizer - It does a good job with the defau
On Nov 11, 2010, at 4:56 PM, Thomas Kellerer wrote:
>
> Actually I think it would be worthwhile documenting your experience in the
> PostgreSQL Wiki as well:
>
> http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
Thanks, I will post something there after I have done some m
hi
had strange situation today.
very high load, cpu saturated (and this machine has lots of cores).
i straced one of backends that was using lots of cpu (it was doing some
select, but I don't know what as i wasn't able to start psql).
strace looked like this:
select(0, NULL, NULL, NULL, {0, 1000
akp geek writes:
> What we do with the text that I have mentioned is, we have
> search functionality on the text. The user enters some keywords and then the
> application should be able to search for all the text that matches the key
> word.
Well, a btree index on the entire string is approximate
hubert depesz lubaczewski writes:
> hi
> had strange situation today.
> very high load, cpu saturated (and this machine has lots of cores).
> i straced one of backends that was using lots of cpu (it was doing some
> select, but I don't know what as i wasn't able to start psql).
> strace looked
On Mon, 2010-11-15 at 13:53 +, Malm Paul wrote:
> I need to download postgreSQL develope package for ver. 8.3.8, but I
> can not find the ...i386.rpm anywhere.
>
> Please, could someone guide me to the right place?
Which distro? If RHEL 5, then:
http://yum.pgsqlrpms.org/8.3/redhat/rhel-5-i3
Dave,
Does your application use temporary tables? This may explain high
autovacuum activity in the catalog tables.
With regards to your tables, I wrote this very script to give me an
indication of the amount of required activity on the user tables. I
deliberately keep this one simple and it doe
On Mon, Nov 15, 2010 at 02:52:16PM -0500, Tom Lane wrote:
> hubert depesz lubaczewski writes:
> > hi
> > had strange situation today.
>
> > very high load, cpu saturated (and this machine has lots of cores).
>
> > i straced one of backends that was using lots of cpu (it was doing some
> > select
Tom Lane wrote:
I'm not nearly as concerned about whether there are forums as about
having "rogue" forums outside the postgresql.org domain. People could
misperceive such things as having some official status
That the site is now mirroring recent news from postgresql.org doesn't
help with tha
I have a table with four columns. Three of those columns are defined as the
composite primary key. Does it make sense to create indexes on any or all of
those three columns individually for performance reasons? PG does let me create
the indexes. But perhaps it's redundant, since there's an impl
On Sun, Nov 14, 2010 at 02:01, Dennis Gearon wrote:
> One thing that makes me agree with this is the antiquated format of the digest
> emails.
I agree - I thought nobody used that anymore :-)
> I hate google mail, but I love the google groups application. If postgres had
> a
> combination onli
On Sat, Nov 13, 2010 at 4:33 PM, Craig Ringer
wrote:
> It can. The glassfish forums are bidirectionally gatewayed to the mailing
> list in just such a manner, and it works astonishingly well. Before using
> those I would've been opposed to the idea, but now ... it doesn't seem so
> bad.
The googl
On Mon, 2010-11-15 at 21:06 +0100, Magnus Hagander wrote:
> I do think that the PostgreSQL lists are available there. And other
> than that, they are on markmail.org, Nabble, etc. AFAIK several of
> those allow both reading and posting. Is there actually something
> about these interfaces that peo
"Dan Halbert" writes:
> I have a table with four columns. Three of those columns are defined
> as the composite primary key. Does it make sense to create indexes on
> any or all of those three columns individually for performance
> reasons?
Please see
http://www.postgresql.org/docs/9.0/static/ind
Dan,
It depends on your application. There is no point in creating an index with
the same 3 columns in the primary key (in the same order).
If you have an index on COL1, COL2 and COL3 (in that order) then if you have
a query such as SELECT COL1, COL2, COL3 from T1 then the index will be
consider
Allan Kamau wrote:
I am now thinking of investing in a SSD (Solid State Drive), and maybe
choosing between "Crucial Technology 256GB Crucial M225 Series
2.5-Inch Solid State Drive (CT256M225)" and "Intel X25-M G2 (160GB) -
Intel MLC".
Both of these are worthless for database applications if you
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Dan Halbert
Sent: Monday, November 15, 2010 12:01 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Indexes on individual columns of composite primary key
I have a table with four columns. Thre
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Dann Corbit
Sent: Monday, November 15, 2010 12:21 PM
To: 'Dan Halbert'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Indexes on individual columns of composite primary key
From: pgsql-general-
I will be deploying Postgres v9 on Linux-64, Sles10 sometime next week. This
will be a production system, so 9.1-alpha2 is probaly off the table.
Are there any serious known bugs left in 9.0.1 that will be addressed in 9.0.2
(if there even will be a 9.0.2)?
Thanks in Advance!
"Apparently (after reading the documentation link provided by Tom) there can
be value to indexes when accessed with leading columns missing".
That is a new one on me too - interesting.
I suppose it comes down to testing at the end of the day - if you "set
enable_seqscan to false" and "EXPLAIN ANA
Dave,
Does your application use temporary tables? This may explain high
autovacuum activity in the catalog tables.
With regards to your tables, I wrote this very script to give me an
indication of the amount of required activity on the user tables. I
deliberately keep this one simple and it doe
Hi Matthew,
Yes, I do have one query that creates a temporary table and that query
runs reasonably often, so that's a good explanation for the catalog tables.
Your query works perfectly on 8.4 and the ratio of dead rows to live
rows is generally quite small so it looks like everything is work
On Mon, 2010-11-15 at 13:25 -0700, Gauthier, Dave wrote:
> Are there any serious known bugs left in 9.0.1 that will be addressed
> in 9.0.2 (if there even will be a 9.0.2)?
Take a look here:
http://git.postgresql.org/gitweb?p=postgresql.git;a=log;h=refs/heads/REL9_0_STABLE
at everything that ha
If anyone's interested, I've started accessing the postgres list through
gmane.org (along with several other mailing lists I subscribe to). It's
gives you the choice of reading the list as a threaded archive, a blog,
or through an NNTP newsreader or an RSS feed. Everyone chooses their
preferred int
Hi,
How do I escape both " and ' to be used in the 'psql -c ' command ?
For example, how to make the psql command {\copy "Table" from
'txt_file'} to be used in the psql with -c option (psql -c) ?
The "Table" has to be double quoted here.
Thanks,
Gary
--
Sent via pgsql-general mailing list (pg
Short answer: for simple commands, you can use shell-escaping of a
double-quoted string.
psql -c "\\copy \"Table\" from 'text file'"
Note: double \\ is intentional. You need to escape the backslash, which
normally escapes other special characters, like $ and ". Watch out for other
special charact
On 15/11/10 19:59, anypossibility wrote:
> Gabriele,
> Thank you for the link. I downloaded the book and read the chapter. Very
> useful information.
>
> Craig,
> The storage type is SAN over AFP.
I very, very strongly suggest getting your SAN host to export an iSCSI
volume to mount directly on
I have made some major changes "beta2"
1. For now the forums have been set to read only, this is to prevent anyone
posting a response (as it doesn't send emails back to the mailing list yet.)
2. Added a bunch of new forums to match the mailing lists, also have subscribed
to all main mailing lis
On 15/11/10 17:37, Thom Brown wrote:
> That's actually some good work you've done there! I didn't know phpBB
> supported bidirectional mailing list support.
Yikes. Neither did I. I've always seen phpBB as the barren wasteland of
web forums - forums full of half-page animated GIF signatures separ
On Nov 14, 2010, at 4:44 AM PST, franrtorres77 wrote:
>
> Hi there
>
> I need to add periodically some data from a remote mysql database into our
> postgresql database. So, does anyone know how to do it having in mind that
> it must be runned every minute or so for adding new records to the
> po
On 16/11/2010, at 2:01 PM, Craig Ringer wrote:
> On 15/11/10 17:37, Thom Brown wrote:
>
>> That's actually some good work you've done there! I didn't know phpBB
>> supported bidirectional mailing list support.
>
> Yikes. Neither did I. I've always seen phpBB as the barren wasteland of
> web for
62 matches
Mail list logo
