Hi
Can somebody point me to some articles/how-to's on postgres clustering
and maybe comparisons to MySQL. (Recently saw an article on scaling
MySQL - up to 16 nodes)
Alex
---(end of broadcast)---
TIP 6: explain analyze is your friend
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Robert Treat) wrote:
> On Thursday 14 September 2006 12:19, Joshua D. Drake wrote:
> > Arturo Perez wrote:
> > > Hi all,
> > >
> > > Any response to this:
> > > http://www.internetnews.com/dev-news/article.php/3631831
> > >
>
> Well first, your
I have seen a steady progressive rise in the number of postgresql
related jobs and the quality of those jobs. Major companies are
apparently rolling out critical infrastructure on postgresql...Vonage
is one example:
(http://jobsearch.monster.com/getjob.asp?JobID=47975237&AVSDM=2006%2D09%2D15+13%
So...
If you're not a PostgreSQL Win32 port dev, and *don't know* what they're
up to as far as Vista, why respond to the Q? Or why respond "fix it
yourself" instead of "ask this guy" or "nobody here will know yet" or
"post your query on -ports or -hackers".
Precisely. My point is not that
Oops, knew I forgot something. Here are the settings from our
postgresql.conf I beilive it's set to allow autovac to work and nothing
else.
# - Query/Index Statistics Collector -
stats_start_collector = on
stats_command_string = off
stats_block_level = off
stats_row_level = on
#stats_reset_o
[EMAIL PROTECTED] writes:
> > ... My biggest concern is the existing FileMakerPro clients. How much
> > work would it be to connect the existing FMP clients to the postgreSQL
> > database using ODBC? Is this a viable temporary step or could it be
> > permanent?
And Tom Lane replies:
> If they
Eci Souji wrote:
We have a 4x 2.4ghz Opteron box w/ 8 gigs of ram running a very busy pg
8.1.4 server. Upon startup we see around 15-20 "statistics buffer is
full" messages and they repeat at random times throughout the day.
During peak times the box sometimes seems to grind to a halt. Any
t
Do you have
stats_command_string=onin postgresql.conf as that might cause this error.If it is truned on please turn it off and then try starting your server.Thanks,-- Shoaib MirEnterpriseDB (
www.enterprisedb.com)On 9/20/06, Eci Souji <[EMAIL PROTECTED]> wrote:
We have a 4x 2.4ghz Opteron box w/ 8
We have a 4x 2.4ghz Opteron box w/ 8 gigs of ram running a very busy pg
8.1.4 server. Upon startup we see around 15-20 "statistics buffer is
full" messages and they repeat at random times throughout the day.
During peak times the box sometimes seems to grind to a halt. Any thoughts?
- E
-
Hey, I've just find out what's happening.
The problem is the "serial" datatype creates a sequence in the background
(project_id_seq). If the sequence current numeber is 1, and I manually insert
a new entry whit ID=2, the sequence doesn't "know" it. So when I try the
INSERT statement, the next value
"Jack Orenstein" <[EMAIL PROTECTED]> writes:
> The C extension I'm writing, which uses the SPI, will be called
> thousands or millions of times as part of a data conversion -- I do
> have to worry about memory leaks.
Not if it's called in a short-lived context, which should ordinarily be
the case.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/19/06 13:26, Steve Atkins wrote:
>
> On Sep 19, 2006, at 11:15 AM, Emi Lu wrote:
>
>> Greetings,
>>
>>
>> *Except* copy command, are there other quick ways to load data from a
>> csv file into a pgsql table please?
>
> There are several bulk l
On 9/19/06, Martijn van Oosterhout wrote:
On Tue, Sep 19, 2006 at 01:27:56PM -0400, Jack Orenstein wrote:
> On 9/18/06, Jack Orenstein <[EMAIL PROTECTED]> wrote:
> >-- Forwarded message --
> >From: Andrew - Supernews <[EMAIL PROTECTED]>
> ...
> > Jack> I have an int8 that I need
On Tue, Sep 19, 2006 at 01:27:56PM -0400, Jack Orenstein wrote:
> On 9/18/06, Jack Orenstein <[EMAIL PROTECTED]> wrote:
> >-- Forwarded message --
> >From: Andrew - Supernews <[EMAIL PROTECTED]>
> ...
> > Jack> I have an int8 that I need as a Datum for use with
> > Jack> SPI_execute
Emi Lu wrote:
Greetings,
*Except* copy command, are there other quick ways to load data from a
csv file into a pgsql table please?
Quick? No.
Joshua D. Drake
Thanks a lot!
---(end of broadcast)---
TIP 5: don't forget to increase your
Thank you for all the inputs.
Actually, I am reluctant to do the update line by line.
I plan to use a shell script to
. replace all characters such as ' to \'
. update each line to insert into
. call "-c query " load the file into db
In java, call this shell script, after data populated into ta
On Tue, 2006-09-19 at 13:27, Brandon Aiken wrote:
> Define 'quick'.
>
> You could write a script that would transform a .csv file into an INSERT
> statement and save it to an .sql file.
>
> Or I suppose you could do silly ODBC stuff with MS Access.
>
> --
> Brandon Aiken
> CS/IT Systems Engineer
On Sep 19, 2006, at 11:15 AM, Emi Lu wrote:
Greetings,
*Except* copy command, are there other quick ways to load data from
a csv file into a pgsql table please?
There are several bulk loaders, but I believe they all use COPY
behind the scenes.
If copy isn't an option then your best be
Define 'quick'.
You could write a script that would transform a .csv file into an INSERT
statement and save it to an .sql file.
Or I suppose you could do silly ODBC stuff with MS Access.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PR
Greetings,
*Except* copy command, are there other quick ways to load data from a
csv file into a pgsql table please?
Thanks a lot!
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Tue, 19 Sep 2006, Tom Lane wrote:
Marc Evans <[EMAIL PROTECTED]> writes:
Any suggested tricks for seeing additional debug information or even
roaming through gdb, to try to figure this out?
Is the problem reproducible enough that you can watch it under gdb?
In that case it shouldn't be th
Marc Evans <[EMAIL PROTECTED]> writes:
> Any suggested tricks for seeing additional debug information or even
> roaming through gdb, to try to figure this out?
Is the problem reproducible enough that you can watch it under gdb?
In that case it shouldn't be that hard to narrow it down. I gathered
I wrote:
> ... I think maybe
> something is applying an UPDATE to the row and losing the new value
> at that point. Are any of the FKs non-default actions (ON ... SET NULL
> or some such that would try to alter data instead of just erroring)?
I've been able to reproduce a problem that may or may
On Tue, 19 Sep 2006, Tom Lane wrote:
Marc Evans <[EMAIL PROTECTED]> writes:
On Tue, 19 Sep 2006, Tom Lane wrote:
Hmph. You got any ON INSERT triggers or rules on that table? I can't
think of anything else that would interfere with data getting stored.
No INSERT triggers. I do have a BEFOR
Marc Evans <[EMAIL PROTECTED]> writes:
> On Tue, 19 Sep 2006, Tom Lane wrote:
>> Hmph. You got any ON INSERT triggers or rules on that table? I can't
>> think of anything else that would interfere with data getting stored.
> No INSERT triggers. I do have a BEFORE DELETE trigger, and a pile of
>
So...
If you're not a PostgreSQL Win32 port dev, and *don't know* what they're
up to as far as Vista, why respond to the Q? Or why respond "fix it
yourself" instead of "ask this guy" or "nobody here will know yet" or
"post your query on -ports or -hackers".
Otherwise it's as useful as saying "
On Tue, 19 Sep 2006, Tom Lane wrote:
Marc Evans <[EMAIL PROTECTED]> writes:
On Tue, 19 Sep 2006, Tom Lane wrote:
What insert command is being issued exactly, and from what source? I'm
speculating about issues like stale plans or metadata caches, but you're
not providing any information about
On 9/18/06, Jack Orenstein <[EMAIL PROTECTED]> wrote:
-- Forwarded message --
From: Andrew - Supernews <[EMAIL PROTECTED]>
...
Jack> I have an int8 that I need as a Datum for use with
Jack> SPI_execute_plan.
Int64GetDatum(your_variable)
which then has to be pfree'd, correct
Marc Evans <[EMAIL PROTECTED]> writes:
> On Tue, 19 Sep 2006, Tom Lane wrote:
>> What insert command is being issued exactly, and from what source? I'm
>> speculating about issues like stale plans or metadata caches, but you're
>> not providing any information about where to look.
> Sorry for bei
On Tue, 19 Sep 2006, Tom Lane wrote:
Marc Evans <[EMAIL PROTECTED]> writes:
On Tue, 19 Sep 2006, Tom Lane wrote:
What do you mean by that exactly? The example you showed seems to be
doing just what it's supposed to.
In the failure mode, the source_record column always has the value NULL,
Marc Evans <[EMAIL PROTECTED]> writes:
> On Tue, 19 Sep 2006, Tom Lane wrote:
>> What do you mean by that exactly? The example you showed seems to be
>> doing just what it's supposed to.
> In the failure mode, the source_record column always has the value NULL,
> regardless of any value specifie
On Tue, 19 Sep 2006, Tom Lane wrote:
Marc Evans <[EMAIL PROTECTED]> writes:
... I have a table with about 15000 records in it, which I
would like to add a new column to. The alter command shows success.
However, testing inserts reveals that the data for the new column is never
stored.
What d
Marc Evans <[EMAIL PROTECTED]> writes:
> ... I have a table with about 15000 records in it, which I
> would like to add a new column to. The alter command shows success.
> However, testing inserts reveals that the data for the new column is never
> stored.
What do you mean by that exactly? The
[EMAIL PROTECTED] (Naz Gassiep) writes:
>> It's the folks who think that non-Windows-using developers should care
>> about Vista that bug me. This is open-source code, people. Scratch
>> your own itch.
>>
> The "scratch your own itch" line can only be pushed so far, if it is
> being said by a dev
Hello -
I am observing odd behavior that I am wondering if anyone here may have an
idea of how better to debug. I am suspecting a bug in the pgsql code, but
would be happy to find it is my error.
My specific situation is that I am using version 8.1.4 on a FreeBSD 6.1
AMD-64 system. I have a
Ben wrote:
Perhaps many of the core developers don't care if windows users take the
project seriously?
Well that may or may not be true, but isn't really relevant. What is
relevant is that *any* community user would have been told the *exact*
same thing. Regardless of OS.
Joshua D. Drake
On Tue, Sep 19, 2006 at 05:11:54PM +0100, Dave Page wrote:
> > Perhaps many of the core developers don't care if windows users take
> > the project seriously?
>
> Somehow I doubt that given that I was invited to join core precisely
> because of my work on the Windows distro. I would think that i
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Ben
> Sent: 19 September 2006 17:03
> To: Naz Gassiep
> Cc: Tom Lane; Ron Johnson; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] vista
>
> Perhaps many of the core developers don't care if w
Perhaps many of the core developers don't care if windows users take
the project seriously?
On Sep 19, 2006, at 4:26 AM, Naz Gassiep wrote:
It's the folks who think that non-Windows-using developers should
care
about Vista that bug me. This is open-source code, people. Scratch
your own
Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2006-09-19 21:26:16 +1000:
if you want to be taken seriously by anyone who uses Windows (hands up
anyone who knows a Windows user)
1. what do those two things have in common?
2. what makes you think that "anyone who uses Windows" runs
taken seriously by professionals in industry. For minor features, yes,
perhaps it could be argued that the core team could ignore certain
issues, and just wait for a patch. For something like Vista
compatibility, if you want to be taken seriously by anyone who uses
Windows (hands up anyone who
Hi Martijn,
Am 2006-09-17 12:22:42, schrieb Martijn van Oosterhout:
> Do you really want this? Compiling static is not straightforward, if
> all the libraries actually exist in static form anyway.
>
> Would it not be easier to install the system in a chroot, then you can
> use all the normal sys
Naz Gassiep <[EMAIL PROTECTED]> writes:
> For something like Vista
> compatibility, if you want to be taken seriously by anyone who uses
> Windows (hands up anyone who knows a Windows user), "scratch your own
> itch" is not really going to cut it, IMHO.
I was responding to someone who is obviou
am Tue, dem 19.09.2006, um 6:11:12 -0700 mailte Lukasz folgendes:
> Hello,
>
> I would like to install a PostgreSQL. I know how to manage the database
> itself, creae databases, user, groups and so on. But I don't know how
> to allow other users, who are outside LAN to connect to database
> thro
> -Original Message-
> From: Martijn van Oosterhout [mailto:[EMAIL PROTECTED]
> Sent: 19 September 2006 15:10
> To: Alban Hertroys
> Cc: Dave Page; Naz Gassiep; Tom Lane; Ron Johnson;
> pgsql-general@postgresql.org
> Subject: Re: [GENERAL] vista
>
> If Vista is so important, why aren'
On 19/9/2006 22:41, "Lukasz" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I would like to install a PostgreSQL. I know how to manage the database
> itself, creae databases, user, groups and so on. But I don't know how
> to allow other users, who are outside LAN to connect to database
> through Interne
> Although Tom's response may have seemed to be negative towards windows,
> the original posting had a bit of an attitude to start with.
Actually the original poster asked "has anybody gotten postgresql to install successfully under
Windows Vista?" To which the answer should have been, "no. Send
John Meyer wrote:
has anybody gotten postgresql to install successfully under Windows
Vista?
---(end of broadcast)---
TIP 6: explain analyze is your friend
BTW, here's the issue at the pgFoundary
http://pgfoundry.org/tracker/index.php?func=det
On Tue, Sep 19, 2006 at 03:34:47PM +0200, Alban Hertroys wrote:
> It is not much harder to say "We currently don't have the resources to
> look into that, if you could be so kind to experiment a bit and see if
> you can get it to work...".
Except that would be a lie. Perhaps:
"Postgresql develo
You have to either configure your router to redirect the public port to the private port. (By
default 5432). Or put your database server in the DMZ (not recommended).
Lukasz wrote:
Hello,
I would like to install a PostgreSQL. I know how to manage the database
itself, creae databases, user, gr
I think the itch and scratch line is entirely appropriate.
This is open source software, not prepackaged code guaranteed to work on the
newest platforms.
People who are trying it out on Vista are developers, not non-technical
end-users.
A developer who wants an open source product to work on a n
Hello Lukasz!
You need some port forwarding onto your router/firewall. You have to forward
incoming connections on port 5432 (or the port postmaster is listening on)
from IP xxx.xxx.xxx.xxx to IP yyy.yyy.yyy.yyy with the according port. If
your router is a Linux machine, take a look into the iptab
On Mon, Sep 18, 2006 at 03:54:05PM -0700, Junkone wrote:
> HI
> I have a table with a unique key constraint on col1,col2. The dattabase
> allowed an multiple inserts. here is how
>
> col1 col2
> 'abc'
> 'abc'
Depends on what you mean by . If you mean NULL, then it's
a
In response to "Tomi NA" <[EMAIL PROTECTED]>:
> On 9/19/06, Roman Neuhauser <[EMAIL PROTECTED]> wrote:
> > # [EMAIL PROTECTED] / 2006-09-19 21:26:16 +1000:
> > > if you want to be taken seriously by anyone who uses Windows (hands up
> > > anyone who knows a Windows user)
> >
> > 1. what do tho
I found a rather strange but working method to compare the contents of two tables in different databases:
select 'otformularfeld' as which, md5(array_to_string(array(
select md5(id_pkff||id_formular||id_formfeld||id_bf) from otformularfeld where quarant=0 order by id_pkff
),''))
So:
- basically
Junkone wrote:
HI
I have a table with a unique key constraint on col1,col2. The dattabase
allowed an multiple inserts. here is how
col1 col2
'abc'
'abc'
I suppose the values in col2 are NULL values?
You cannot compare NULL values. NULL == NULL evaluates to NULL (n
Tomi NA wrote:
On 9/19/06, Roman Neuhauser <[EMAIL PROTECTED]> wrote:
# [EMAIL PROTECTED] / 2006-09-19 21:26:16 +1000:
> if you want to be taken seriously by anyone who uses Windows (hands up
> anyone who knows a Windows user)
1. what do those two things have in common?
2. what makes yo
Dave Page wrote:
because someone couldn't find the feature they wanted and were
encouraged to work on it themselves. pgAdmin got started in almost
^^
That's the key word here, "encouraged", not "discouraged". IMHO telling
a Windows user to go do it himself is discouraging. Quite impol
The free, open-source SchemaCrawler tool will compare the schema and
data. SchemaCrawler outputs details of your schema (tables, views,
procedures, and more) in a diff-able plain-text format (text, CSV, or
XHTML). SchemaCrawler can also output data (including CLOBs and BLOBs)
in the same plain-text
The solution you need all depends on the problem you are having. If you
explain how your application is written PHP, Java, etc and where your
performance problems are coming from, then someone could give you a better
answer!
Regards,
Ben
"Najib Abi Fadel" <[EMAIL PROTECTED]> wrote in message
HI
I have a table with a unique key constraint on col1,col2. The dattabase
allowed an multiple inserts. here is how
col1 col2
'abc'
'abc'
I am not sure how this can happen
---(end of broadcast)---
TIP 1: if posting/rea
Hello,
I would like to install a PostgreSQL. I know how to manage the database
itself, creae databases, user, groups and so on. But I don't know how
to allow other users, who are outside LAN to connect to database
through Internet.
For example, my external IP is xxx.xxx.xxx.xxx, and my IP in the
Hi,
I have an application using Postgresql with a large (100+) number of
tables. Are there any free/open source tools that can ease the process
of updating the schema.
Specifically I would like to compare a source and a target, determine
the differences and the best way to update the target to
On 9/19/06, Roman Neuhauser <[EMAIL PROTECTED]> wrote:
# [EMAIL PROTECTED] / 2006-09-19 21:26:16 +1000:
> if you want to be taken seriously by anyone who uses Windows (hands up
> anyone who knows a Windows user)
1. what do those two things have in common?
2. what makes you think that "an
> -Original Message-
> From: Naz Gassiep [mailto:[EMAIL PROTECTED]
> Sent: 19 September 2006 14:06
> To: Dave Page
> Cc: Tom Lane; Ron Johnson; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] vista
>
> "That's important and we acknowledge the need."
> Even in the absence of any p
# [EMAIL PROTECTED] / 2006-09-19 21:26:16 +1000:
> if you want to be taken seriously by anyone who uses Windows (hands up
> anyone who knows a Windows user)
1. what do those two things have in common?
2. what makes you think that "anyone who uses Windows" runs
PostgreSQL on it?
So what do you suggest? -core vote and "order" someone to do the work?
Postgresql.org isn't a business and doesn't employ any developer - we
only have the option of accepting patches from people/companies with
itches.
I don't suggest any chance to any structures in place, it's a purely PR
p
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Naz Gassiep
> Sent: 19 September 2006 12:26
> To: Tom Lane
> Cc: Ron Johnson; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] vista
>
>
> The "scratch your own itch" line can only be pushed s
It's the folks who think that non-Windows-using developers should care
about Vista that bug me. This is open-source code, people. Scratch
your own itch.
The "scratch your own itch" line can only be pushed so far, if it is
being said by a developer who works on a project that desires to be
[EMAIL PROTECTED] writes:
> At a customer site, we've made a migration from Oracle 8.1.5 to PGSQL
> 8.1.1. The migration happened without any problem and now the performances
> are better with PG than with Ora, but the customer noticed that the size
> of PG on disk where much greater than the siz
Hi Benoit,
Are you talking specifically the database?
You can run up 100's of gigs of log files in pg_log if you're not careful (he
says after doing the very same).
Cheers
Chris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 19 September 2006 10:01
To:
Hi,
At a customer site, we've made a migration from Oracle 8.1.5 to PGSQL
8.1.1. The migration happened without any problem and now the performances
are better with PG than with Ora, but the customer noticed that the size
of PG on disk where much greater than the size on disk of Oracle. And I'm
n
Ron Johnson wrote:
# select * from projects;
project_id | username | project_name
- +--+--
1 | foo |
2 | bar |
(2 rows)
dupe_filenames=# insert into projects (project_name, username )
dupe_filenames-# values ('foo', 'bar');
ERROR:
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
> Sent: 19 September 2006 05:43
> To: Ron Johnson
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] vista
>
> Ron Johnson <[EMAIL PROTECTED]> writes:
> > On 09/18/06 22:32, Joshu
> > Well, we are entirely ready to accept patches from any Windows
> Vista
> > beta testers who are able to find and fix portability issues.
> >
> > It's the folks who think that non-Windows-using developers should
> care
> > about Vista that bug me. This is open-source code, people.
> Scratch
> >
75 matches
Mail list logo