On top of what the other poster said, I'm wondering if you're not
getting any kind of postmaster not cleanly shutdown, recovery
initiated or something like that when you first start it up. You
don't tend to see a lot of messages after that until recovery is
completed.
What does top and / or
On Tue, Mar 17, 2009 at 6:31 AM, Subha Ramakrishnan su...@gslab.com wrote:
I use postgresql 8.3.1 with postgis 1.3.3.
Don't know about the other stuff, but is there a good reason you're
running such an old release of 8.3?
-
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
On Tue, 2009-03-17 at 17:59 -0700, Jack W wrote:
I set up a failover system with one primary server and one standby
server.
In the standby server's log, I saw the lines like below:
Command for restore: copy E:\archive\0001004C
pg_xlog\RECOVERYXLOG
The above line
On Wed, 2009-03-18 at 11:19 +0530, Ashish Karalkar wrote:
Postgres Plus does support Linux and it includes all the PostgreSQL
features as well as have many other additional useful features.One of
which is its dyna tune module.
You can check through the webpage
At 10:00 PM 3/17/2009, Harald Armin Massa wrote:
Merlin,
I agree though
that a single table approach is best unless 1) the table has to scale
to really, really large sizes or 2) there is a lot of churn on the
data (lots of bulk inserts and deletes).
while agreeing, an additional question:
At 12:05 AM 3/18/2009, Erik Jones wrote:
On Mar 17, 2009, at 4:47 AM, Craig Ringer wrote:
The question is: Which DBMS do you think is the best for this kind of
application? PostgreSQL or MySQL?
As you can imagine, PostgreSQL.
My main reasons are that in a proper transactional environment
No specific reason for using the old version.
Still in the process of upgrading the softwares that we are using in the
project.
Soon, we'll be using the latest version.
Does using an old version stop me from using a particular functionality?
Subha
Scott Marlowe wrote:
On Tue, Mar 17, 2009 at
On Wed, Mar 18, 2009 at 1:31 AM, Subha Ramakrishnan su...@gslab.com wrote:
No specific reason for using the old version.
Still in the process of upgrading the softwares that we are using in the
project.
Soon, we'll be using the latest version.
Does using an old version stop me from using a
On Tue, Mar 17, 2009 at 11:27 PM, Scott Marlowe scott.marl...@gmail.com wrote:
Hard to say with what you've told us so far.
what more should I post/need? I was suspecting that as well as I've
never had postgres be silent and not work -- I've also never let a db
fill its disk and get f'ed like
ogr2ogr can write most formats to most other formats. It can certainly write to
a PostGIS database, read KML., so if it can write it to shape, it can write
direct to Postgis
You just need to set your output format to postgis.
Note: depending on where you got GDAL (ogr2ogr) from, it may or may
On Wed, Mar 18, 2009 at 2:18 AM, Aaron Glenn aaron.gl...@gmail.com wrote:
On Tue, Mar 17, 2009 at 11:27 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
Hard to say with what you've told us so far.
what more should I post/need? I was suspecting that as well as I've
Remember that mentiion of
That would be great.
I do have GDAL compiled with postgis.
I'll definitely try this option.
Thanks a lot.
Subha
Brent Wood wrote:
ogr2ogr can write most formats to most other formats. It can certainly write to a
PostGIS database, read KML., so if it can write it to shape, it can write
Simon Riggs wrote:
On Wed, 2009-03-18 at 11:19 +0530, Ashish Karalkar wrote:
Postgres Plus does support Linux and it includes all the PostgreSQL
features as well as have many other additional useful features.One of
which is its dyna tune module.
You can check through the webpage
I've this view:
create or replace view catalog_promosimple_v as
select p.PromoSimpleID,
p.IsPromo, p.Percent, p.OnListPrice, p.Vendible,
p.OnStock, p.Dist, p.PromoStart, p.PromoEnd, pi.ItemID, pi.Discount
from catalog_promosimple p
join catalog_promosimpleitem pi on
durumdara wrote:
Can I define in PGSQL, which DataBases can read from the localhost, and
which can from the net?
Yes. See authentication in the manuals for details on pg_hba.conf and
also grant connect. Only allow password-protected connection over an
encrypted ssl channel. Only allow
On Wed, 2009-03-18 at 14:36 +0530, Ashish Karalkar wrote:
Simon Riggs wrote:
On Wed, 2009-03-18 at 11:19 +0530, Ashish Karalkar wrote:
Postgres Plus does support Linux and it includes all the PostgreSQL
features as well as have many other additional useful features.One of
which is
Hi,
I'm using Postgresql 8.3.6 under Freebsd 7.1.
After a fresh restore of a customer dump (running version 8.2.7 at the
moment), a rather big query executes in about 30 seconds. As soon as I
run ANALYZE, it is instantly 4-5 times slower. I could check that
multiples times.
Here is the EXPLAIN
On Wed, 18 Mar 2009 09:32:56 +0100
durumdara durumd...@gmail.com wrote:
Possible he can install an another pgsql service that can be
opened to the net and that can usable for ONLY THIS PROJECT. But I
don't know, that is possible or not; and how to upgrade later, if
needed... :-(
If you can't
On Wed, Mar 18, 2009 at 9:53 AM, Simon Riggs si...@2ndquadrant.com wrote:
Exactly my point: it is not a value-add for Postgres Plus, which was the
only value-add you mentioned. Those features either work with standard
Postgres distro, or they are not available unless you use the non-free,
John Cheng wrote:
This is question for Juan, have you asked the MySQL mailing list?
Not yet. Admitting my ignorance in databases, I'm trying to understand all
the concepts discussed in this thread .
Be sure today I will ask the MySQL list.
Thanks
2009/3/17 John Cheng chonger.ch...@gmail.com
Merlin Moncure mmonc...@gmail.com writes:
A good rule of thumb for large is table size working ram. Huge
(really large) is 10x ram.
Or better yet, large is data working ram. Very large is data directly
attached drives... That means that without fairly expensive hardware you start
talking
In response to Philippe Lang philippe.l...@attiksystem.ch:
I'm using Postgresql 8.3.6 under Freebsd 7.1.
After a fresh restore of a customer dump (running version 8.2.7 at the
moment), a rather big query executes in about 30 seconds. As soon as I
run ANALYZE, it is instantly 4-5 times
Thanks Stuart
I will try Ubuntu image at Amazon cloud. Seems..they are looking for testers
too. Not much of tester, but will be able to at least post to list if
something fails ;-) Will try centos after that.
With best regards.
Sanjay Arora.
On Tue, Mar 17, 2009 at 12:10 PM, Stuart Bishop
Bill Moran wmo...@potentialtech.com writes:
I opened one of those links figuring I'd take a few minutes to see if I could
muster up some advice ... and just started laughing ... definitely not the
type of query that one can even understand in just a few minutes!
You might consider setting
In response to Philippe Lang philippe.l...@attiksystem.ch:
I'm using Postgresql 8.3.6 under Freebsd 7.1.
After a fresh restore of a customer dump (running version 8.2.7 at the
moment), a rather big query executes in about 30 seconds. As soon as I
run ANALYZE, it is instantly 4-5 times
Hi all, i need make a report of all comments in the all tables.
Where postgres storage it?
Thanks
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com
Hi,
Can we use sql transactions(BEGIN, ROllBACK, COMMIT etc) in a postgresql
function(user defined) which is written in PL/Perl?
Thanks in advance
--
With warm regards
Jasid Z. A
+91 9946109809
paulo matadr wrote:
Hi all, i need make a report of all comments in the all tables.
Where postgres storage it?
Thanks
Veja quais são os assuntos do momento no Yahoo! + Buscados: Top 10
Jasid ZA za.ja...@gmail.com wrote:
Hi,
Can we use sql transactions(BEGIN, ROllBACK, COMMIT etc) in a postgresql
function(user defined) which is written in PL/Perl?
No. A function is an autonomous transaction. You can use savepoints.
Andreas
--
Really, I'm not out to destroy Microsoft.
Oh, the other thing you could try experimenting with are these two parameters.
Your query has *way* more tables than the default values for these so you
would have to raise them substantially. Given that the query was running in
30s you may find that this increases the planning time by more time
hi
it's look better with explain.depesz.com :) you can easily find that
in before it uses index scan and in after it uses seq
before:
http://explain.depesz.com/s/RC
after:
http://explain.depesz.com/s/nm
try as mentioned before to change costs
Best regards,
Sebastian Pawłowski
Andreas Kretschmer wrote:
Jasid ZA za.ja...@gmail.com wrote:
Hi,
Can we use sql transactions(BEGIN, ROllBACK, COMMIT etc) in a postgresql
function(user defined) which is written in PL/Perl?
No. A function is an autonomous transaction. You can use savepoints.
This question comes up
Alvaro Herrera alvhe...@commandprompt.com wrote:
Andreas Kretschmer wrote:
Jasid ZA za.ja...@gmail.com wrote:
Hi,
Can we use sql transactions(BEGIN, ROllBACK, COMMIT etc) in a postgresql
function(user defined) which is written in PL/Perl?
No. A function is an autonomous
Andreas Kretschmer wrote:
Alvaro Herrera alvhe...@commandprompt.com wrote:
Andreas Kretschmer wrote:
Jasid ZA za.ja...@gmail.com wrote:
Hi,
Can we use sql transactions(BEGIN, ROllBACK, COMMIT etc) in a postgresql
function(user defined) which is written in PL/Perl?
On Wed, Mar 18, 2009 at 01:18:46AM -0700, Aaron Glenn wrote:
On Tue, Mar 17, 2009 at 11:27 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
start run it's course? for a 35GB+ database how long should I wait? is
there no way to log the status of what the postgres daemon is actually
doing
On Wed, 2009-03-18 at 11:19 +0530, Ashish Karalkar wrote:
Postgres Plus does support Linux and it includes all the PostgreSQL
features as well as have many other additional useful features.One of
which is its dyna tune module.
Yes it does, but it doesn't use native packages (as far as I
pgsql-general-ow...@postgresql.org wrote:
In response to Philippe Lang philippe.l...@attiksystem.ch:
I'm using Postgresql 8.3.6 under Freebsd 7.1.
After a fresh restore of a customer dump (running version 8.2.7 at
the moment), a rather big query executes in about 30 seconds. As
soon as I
Alvaro Herrera wrote:
Andreas Kretschmer wrote:
Alvaro Herrera alvhe...@commandprompt.com wrote:
Andreas Kretschmer wrote:
Jasid ZA za.ja...@gmail.com wrote:
Hi,
Can we use sql transactions(BEGIN, ROllBACK, COMMIT etc) in a postgresql
function(user defined) which is written in PL/Perl?
Tino Wildenhain wrote:
But this sounds like fun, I'll check how to add something to the
documentation :-)
Of course it is fun. Why else do you think I spend time on it?
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting,
In response to Philippe Lang philippe.l...@attiksystem.ch:
[snip]
Anyway, the real reason I posted -- I doubt if anyone will be able to
make sense of a query plan that complex without the actual query, so
you'll probably want to post it as well.
:) What? I thought you would read that
Hi
Don't know if this is the correct forum for this, if not please point me in
the correct direction but have installed 8.3.6.1 in a windows 2003 64 bit
server, in the default directories for the program files, data on a
seperate drive, set up postgres as a local user with admin rights, but when
Hi:
I have max_fsm_relations set to 1200 and max_fsm_pages set to 20 in
postgres.conf (well over 16x max_fsm_relations) but still get...
FATAL: max_fsm_pages must exceed nax_fsm_relations * 16
What's up ?
(v8.3 on Linux)
Nevermind (wrong postgres.conf, in wrong dir) Sorry.
-dave
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gauthier, Dave
Sent: Wednesday, March 18, 2009 11:13 AM
To: pgsql-general@postgresql.org
Subject:
Question How many database objects or relations do you have?
Thanks
Deepak
On Wed, Mar 18, 2009 at 8:12 AM, Gauthier, Dave dave.gauth...@intel.comwrote:
Hi:
I have max_fsm_relations set to 1200 and max_fsm_pages set to 20 in
postgres.conf (well over 16x max_fsm_relations) but still
juankarlos.open...@gmail.com (Juan Pereira) writes:
Quite interesting! The main reason why we thought using a table per
truck was because concurrent load: if there are 100 trucks trying to
write in the same table, maybe the performance is worse than having
100 tables, due to the fact that the
On Wed, Mar 18, 2009 at 7:11 PM, Andreas Kretschmer
akretsch...@spamfence.net wrote:
Jasid ZA za.ja...@gmail.com wrote:
Hi,
Can we use sql transactions(BEGIN, ROllBACK, COMMIT etc) in a postgresql
function(user defined) which is written in PL/Perl?
No. A function is an autonomous
I'm trying to use Perl's DBD::Pg module to import a file as a large object.
For this I'm using the following:
my $oid = $dbh-func( /absolute/path/to/file, 'lo_import' );
When I do this, a new record is added to pg_largeobject, with a
proper-looking non-null loid, but the data field remains
On Wed, Mar 18, 2009 at 2:40 PM, Ivan Sergio Borgonovo m...@webthatworks.it
wrote:
If the view is just an alias for the SQL as text and it is not
interpreted at creation time...
This assumption is wrong. A view is compiled at creation time, and the
compiled version of the view is used in
Marco Colombo wrote:
Ron Mayer wrote:
Greg Smith wrote:
There are some known limitations to Linux fsync that I remain somewhat
concerned about, independantly of LVM, like ext3 fsync() only does a
journal commit when the inode has changed (see
Hi,
I have a DB in utf-8 and postgres 8.3.x.
How can I do an accent insensitive search (like ...) ?
TIA
Hi,
use ILIKE
HTH,
Pedro Doria Meunier
GSM: +351961720188
Skype: pdoriam
On Wednesday 18 March 2009 04:29:24 pm cifroes wrote:
Hi,
I have a DB in utf-8 and postgres 8.3.x.
How can I do an accent insensitive search (like ...) ?
TIA
signature.asc
Description: This is a digitally
Not case insensitive but accent insensitive :)
And I tried select to_ascii('capo','LATIN1'), to_ascii('çapo','LATIN1') and the
results are different
-Original Message-
From: pgsql-general-ow...@postgresql.org on behalf of Pedro Doria Meunier
Sent: Wed 3/18/2009 4:46 PM
To:
2009/3/18 Pedro Doria Meunier pdo...@netmadeira.com
Hi,
use ILIKE
HTH,
ILIKE is only case-insensitive, and won't match accented characters. The
only thing I can think of doing is to create a function which will replace
characters with their equivalent non-accented counterparts and use
Here's an example of a function I might use (although I haven't actually got
plperl installed, so can't test it myself, but you'll get the idea:
CREATE OR REPLACE FUNCTION unaccent_string(text) RETURNS text AS $$
my ($input_string) = @_;
$input_string =~ s/[âãäåāăą]/a;
$input_string =~
On Wed, Mar 18, 2009 at 04:29:24PM -, cifroes wrote:
I have a DB in utf-8 and postgres 8.3.x.
How can I do an accent insensitive search (like ...) ?
No good idea at the moment; I'd somehow expect to find this sort of
normalization in the functionality provided by the text search code.
My
Ooops!
Silly me! I should have read more carefully ... (blush) sorry!
Pedro Doria Meunier
GSM: +351961720188
Skype: pdoriam
On Wednesday 18 March 2009 04:46:16 pm Pedro Doria Meunier wrote:
Hi,
use ILIKE
HTH,
Pedro Doria Meunier
GSM: +351961720188
Skype: pdoriam
On Wednesday 18 March
2009/3/18 Sam Mason s...@samason.me.uk
If you can't find anything better in PG; the translate[1] function would
be my best suggestion. Performance should be better than using regular
expressions.
Yeah, that does appear to perform better. I tried the following at it
worked for me:
CREATE
Sam Mason wrote on 18.03.2009 18:15:
On Wed, Mar 18, 2009 at 04:29:24PM -, cifroes wrote:
I have a DB in utf-8 and postgres 8.3.x.
How can I do an accent insensitive search (like ...) ?
No good idea at the moment; I'd somehow expect to find this sort of
normalization in the
how about...
select where translate(lower(myfield),
'âãäåāăąèééêëēĕėęěìíîïìĩīĭóôõöōŏőùúûüũūŭů',
'aaaeeooouuu') = 'stringiwannamatch';
or something like that. I may have miscounted the vowells in the 'to'
string :)
-
Sent via pgsql-general mailing
What I've done in the past in this situation is to create a separate
field with the text normalized to whatever the search form is (all
lower case, accents stripped, etc.), and then index and search that
from the application.
Although I've not tried it, a functional index that did the same
I would suggest you join the Perl DBI mailing list and ask your question
there. There are some quite capable people in that group who could help
you troubleshoot this issue.
It's called dbi-us...@perl.org. Look at
http://lists.cpan.org/showlist.cgi?name=dbi-users, where it tells you
how to
If this questions belongs on a different listserv, please let me know.
I've got a question regarding ./configure.
In v. 8.013 (okay, I'm running old stuff) we had the following options:
--with-java
--with-multibyte
--with-unicode
In attempting to upgrade to 8.3.7, those flags are ignored.
On Wed, 18 Mar 2009, cifroes wrote:
Hi,
I have a DB in utf-8 and postgres 8.3.x.
How can I do an accent insensitive search (like ...) ?
Take a look on text search capability and
http://www.sai.msu.su/~megera/wiki/unaccent
We have patches for CVS HEAD, but unfortunately they will likely
go
Thom Brown escribió:
Here's an example of a function I might use (although I haven't actually got
plperl installed, so can't test it myself, but you'll get the idea:
CREATE OR REPLACE FUNCTION unaccent_string(text) RETURNS text AS $$
my ($input_string) = @_;
$input_string =~ s/[âãäåāăą]/a;
On Mar 18, 2009, at 11:24 AM, Alvaro Herrera wrote:
Hmm, if to_ascii() doesn't work, that's something worth some research.
Maybe the encoding config is broken, for example.
The docs say to_ascii() only works with LATIN1, LATIN2, LATIN9, and
WIN1250; maybe convert('string', 'UTF-8',
On Wednesday 18 March 2009 19:50:17 Jeffrey Trimble wrote:
I've got a question regarding ./configure.
In v. 8.013 (okay, I'm running old stuff) we had the following options:
--with-java
--with-multibyte
--with-unicode
In attempting to upgrade to 8.3.7, those flags are ignored. That's
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
I'm trying to use Perl's DBD::Pg module to import a file as a large object.
For this I'm using the following:
my $oid = $dbh-func( /absolute/path/to/file, 'lo_import' );
Works fine for me. What version of DBD::Pg are you using? Try
Philippe Lang philippe.l...@attiksystem.ch writes:
A small question here: solde_po is an SQL function (not PLPGSQL). Is it
inlined in the parent query before the whole query execution plan is
calculated?
You should be able to tell that by inspecting the filter conditions
in the ANALYZE output.
Dear Sirs,
I would like to rent a my application to a number of customer, each with a
dedicated database (and perhaps a dedicated username).
The database will be installed on 'public IP' machine and will be accessed
by internet on standard port 5432 and using ODBC driver from several clients
On Wed, Mar 18, 2009 at 09:15:31PM +0100, dfx wrote:
It is possible to configure the security policy so that the simple users
(the customer, in this case) can only read, write, update end delete data to
the dedicated database AND NOTHING ELSE, particularly:
I assume you're implying a caveat
In response to dfx d...@dfx.it:
Dear Sirs,
I would like to rent a my application to a number of customer, each with a
dedicated database (and perhaps a dedicated username).
The database will be installed on 'public IP' machine and will be accessed
by internet on standard port 5432 and
Greg Smith wrote:
On Wed, 18 Mar 2009, Marco Colombo wrote:
If you fsync() after each write you want ordered, there can't be any
subsequent I/O (unless there are many different processes
cuncurrently writing to the file w/o synchronization).
Inside PostgreSQL, each of the database backend
I downloaded the 8.3 exe for Windows (XP) and started the
installation. When it got near the end, a warning window opened
stating Problem running post-install step. Installation may not
complete correctly. Failed to start the database server.
When I openned the pgadmin, the server pane showed
All,
I am porting a database from MS SQL Server to Postgres. One of the
tables contains a list of names, which I would like to list
alphabetically. I noticed in the O names the following difference:
MSSQL:
O'Daniel
O'Neill
Oliveira
Oliver
While PGSQL sorts as if the apostrophe
On 18/03/2009 21:10, ray wrote:
I downloaded the 8.3 exe for Windows (XP) and started the
installation. When it got near the end, a warning window opened
stating Problem running post-install step. Installation may not
complete correctly. Failed to start the database server.
Did you select
On Wed, Mar 18, 2009 at 10:58:39PM +0100, Marco Colombo wrote:
I hope it's full defence. If you have two processes doing at the
same time write(); fsycn(); on the same file, either there are no order
requirements, or it will boom sooner or later... fsync() works inside
a single process, but
Ron Mayer wrote:
Marco Colombo wrote:
Ron Mayer wrote:
Greg Smith wrote:
There are some known limitations to Linux fsync that I remain somewhat
concerned about, independantly of LVM, like ext3 fsync() only does a
journal commit when the inode has changed (see
On Wed, 18 Mar 2009, Martijn van Oosterhout wrote:
Generally PG uses O_SYNC on open
Only if you change wal_sync_method=open_sync. That's the very last option
PostgreSQL will try--only if none of the other are available will it use
that.
Last time I checked the defaults value for that
On Mar 18, 5:07 pm, r...@iol.ie (Raymond O'Donnell) wrote:
On 18/03/2009 21:10, ray wrote:
I downloaded the 8.3 exe for Windows (XP) and started the
installation. When it got near the end, a warning window opened
stating Problem running post-install step. Installation may not
complete
Martijn van Oosterhout wrote:
Generally PG uses O_SYNC on open, so it's only one system call, not
two. And the file it's writing to is generally preallocated (not
always though).
It has to wait for I/O completion on write(), then, it has to go to
sleep. If two different processes do a write(),
Bryan Herger wrote:
I am porting a database from MS SQL Server to Postgres. One of the
tables contains a list of names, which I would like to list
alphabetically. I noticed in the O names the following difference:
Note to whoever answers: this is a frequent question, so consider adding
your
Alvaro Herrera alvhe...@commandprompt.com writes:
Bryan Herger wrote:
I am porting a database from MS SQL Server to Postgres. One of the
tables contains a list of names, which I would like to list
alphabetically. I noticed in the O names the following difference:
Note to whoever answers:
82 matches
Mail list logo