On Jan 29, 2008 6:30 PM, Chander Ganesan <[EMAIL PROTECTED]> wrote:
>
> > Is it possible to point two servers running PGPool at the same two
> > database servers? If so, I seem to recall reading about being able to
> > use some kind of virtual IP address to split the traffic to both.
> CARP...I've
><[EMAIL PROTECTED]> writes:
>> CREATE INDEX request_day_idx ON moksha_sm_request >(date_trunc('day',
>request_received));
>...
>> I'd be grateful if someone could point out what part of the statement >is not
>> IMMUTABLE or how I could mark my create index statement as being >immutable.
>date
Hello,
we like to use PostgreSQL in an embedded system that runs - don't laugh
- on a compact flash.
Therefore we need to know how often PostgreSQL will write to the disc.
Once our system is configured there are very little changes to the
database.
We have some tables in memory and some
Bob,
First, Which exact version of S10 are you using ?
In general, I have seen having logs and data on different pools helps.
Also, let us know your wal tunning parameters like commit_delay, fsync.
If you are using S10u4, setting commit_delay to a non zero number should
help get better perform
Mayuresh,
comments in-lined, below ...
- Original Message
> From: Mayuresh Nirhali <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: pgsql-general@postgresql.org
> Sent: Thursday, January 31, 2008 6:23:23 AM
> Subject: Re: [GENERAL] Performance problems with Postgresql/ZFS/Non-global
>
On Tue, Jan 29, 2008 at 06:49:50PM +0100, Ivan Sergio Borgonovo wrote:
> On Tue, 29 Jan 2008 17:17:39 + Sam Mason <[EMAIL PROTECTED]> wrote:
> > I've tended to do:
> >
> > SELECT *
> > FROM (
> > SELECT "complicated expression" AS pippo) x
> > WHERE pippo < 12;
>
> It risk to be mu
Simon Riggs wrote:
On Fri, 2008-01-25 at 11:34 +1100, Phillip Smith wrote:
We have a center in Europe who has just started to use PostgreSQL and was
asking me if there are any Symantec product or other products that backup
this type of database.
It doesn't appear to.
The design
On Wed, Jan 30, 2008 at 09:52:17AM +0100, H??kan Jacobsson wrote:
> I just realised that issuing the SQL on one table produces the correct count.
>
> SELECT sum(case when table2.date between '2007-07-13' and '2007-07-13' then 1
> else 0
> end) as sumx FROM table2 WHERE id = n;
>
> This is workin
[Following up on my own message.]
>
Also,
> >
> let
> >
> us
> >
> know
> >
> your
> >
> wal
> >
> tunning
> >
> parameters
> >
> like
> >
> commit_delay,
> >
> fsync.
I haven't done any tuning as of yet. I'm running with the default settings
produced by initdb.
Bob
--
On 29 jan, 18:42, cbmeeks <[EMAIL PROTECTED]> wrote:
> I love MySQL but I'm concerned about it's future. And, I'm always
> looking to learn something new. I love the licensing model of
> Postgres.
>
> Anyway, using online documentation, I've managed to get a server
> running but I find myself con
On 30 jan, 04:14, Jon Hancock <[EMAIL PROTECTED]> wrote:
> I have compiled postgres 8.3rc2 on ubuntu 7.04 and seem to a have
> working install.
> To start postgres, I do the following:
>
> > su postgres
> > /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data &
>
> ok, that works for dev mode. B
Am Donnerstag, 31. Januar 2008 schrieb Andre Nieder:
> So is there any reason that should prevent us from using PostgreSQL in
> combination with a compact flash?
I suggest you review the previous discussions on this topic. Search
for "compact flash" on archives.postgresql.org. You will find tha
On Thu, 2008-01-31 at 07:21 -0500, Chander Ganesan wrote:
> If you don't mind if you lose some transactions
That sentence has no place in any discussion about "backup" because the
risk is not just a few transactions, it is a corrupt and inconsistent
database from which both old and new data would
Hi Willem,
Il giorno 30/gen/08, alle ore 22:15, Willem Buitendyk ha scritto:
I'm trying to replicate the use of Oracle's 'lag' and 'over
partition by' analytical functions in my query. I have a table
(all_client_times) such as:
client_id, datetime
122, 2007-05-01 12:00:00
122, 2007-05-01
I've noticed that by default postgres writes its log files read/write
only by the postgres user.
I have a nagios user I want to be able to analyse the logs.
Is there a way to make postgres output them so they can be read by a
group? Or am I going to have to write a script?
Glyn
_
On Thu, Jan 31, 2008 at 02:35:01AM -0800, T.J. Adami wrote:
> Everytime I deploy a PostgreSQL server in a ubuntu or debian based
> server, I create some scripts called pg_start, pg_stop and pg_reload,
> save them on default postgresql home dir. Then I create symbolic links
> on /usr/bin, and so on
T.J. Adami wrote:
I am also searching for a more 'professional' way to startup and
shutdown postgresql on ubuntu and debian systems.
The source comes with a startup script that can be installed by
running:
# cp contrib/start-scripts/linux /etc/init.d/postgresql
# update-rc.d postgres
On 1/31/08, Glyn Astill <[EMAIL PROTECTED]> wrote:
> I've noticed that by default postgres writes its log files read/write
> only by the postgres user.
>
> I have a nagios user I want to be able to analyse the logs.
>
> Is there a way to make postgres output them so they can be read by a
> group? O
On Thu, Jan 31, 2008 at 01:28:48PM +, Simon Riggs wrote:
> That sentence has no place in any discussion about "backup" because the
> risk is not just a few transactions, it is a corrupt and inconsistent
> database from which both old and new data would be inaccessible.
Hmm? I thought the whole
> Josh,
>
> > Myself and a small team of PostgreSQL contributors have started a new
> > community project for PostgreSQL Certification. It is just launching
> > but we wanted to get it out there so that people can join in on the
> > discussion now :).
>
> Who else is in this? Have you talked to
Simon Riggs wrote:
On Thu, 2008-01-31 at 07:21 -0500, Chander Ganesan wrote:
If you don't mind if you lose some transactions
That sentence has no place in any discussion about "backup" because the
risk is not just a few transactions, it is a corrupt and inconsistent
database from which
Douglas McNaught wrote:
> On 1/31/08, Glyn Astill <[EMAIL PROTECTED]> wrote:
> > I've noticed that by default postgres writes its log files read/write
> > only by the postgres user.
> >
> > I have a nagios user I want to be able to analyse the logs.
> >
> > Is there a way to make postgres output th
On Thu, Jan 31, 2008 at 03:34:05PM +0100, Martijn van Oosterhout wrote:
> On Thu, Jan 31, 2008 at 01:28:48PM +, Simon Riggs wrote:
> > That sentence has no place in any discussion about "backup" because the
> > risk is not just a few transactions, it is a corrupt and inconsistent
> > database f
--- Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> >
> > PG itself only writes to stdout/stderr or uses syslog(). The way
> logs
> > are generated and stored is distro-specific, so you need to look
> at
> > how your distro does things (perhaps modifying the startup
> script).
>
> Actually, as of 8
> Simon Riggs wrote:
>> As far as I am concerned, if any Postgres user loses data then we're all
>> responsible.
Remember, our license says this software is given without any warranty
whatsoever, implicit or explicit, written or implied, given or sold,
alive or deceased.
--
Alvaro Herrera
Tatsuo Ishii wrote:
Josh,
However running a certification programs (not just making examins) is
not a trivial work. Moreover it costs a lot of money (over $40,000 per
year in our case). Josh, how do you overcome those problems?
As the resources become required I am sure that I can make sure t
> > I'm trying to replicate the use of Oracle's 'lag' and 'over
> > partition by' analytical functions in my query. I have a table
> > (all_client_times) such as:
> > and I would like to create a new view that takes the first table and
> > calculates the time difference in minutes between each row
On Jan 31, 2008, at 12:51 AM, Gregory Williamson wrote:
Bruce Momjian said:
> Tom Hart wrote:
> > I definitely think that the lists are one of the shining stars for
> > postgresql support. I've learned some good reference stuff from
online
> > docs/google but the really tricky questions were
Magnus Hagander wrote:
On Thu, Jan 31, 2008 at 03:34:05PM +0100, Martijn van Oosterhout wrote:
On Thu, Jan 31, 2008 at 01:28:48PM +, Simon Riggs wrote:
That sentence has no place in any discussion about "backup" because the
risk is not just a few transactions, it is a corrupt and in
On Jan 31, 2008, at 4:28 AM, Aaron Glenn wrote:
CARP *and* pfsync.
this late at night off the top of my head I can't see any blatantly
obvious reason this wouldn't work (with at least pgpool that is, dunno
about your data)
we use CARP to balance and failover some webserver pairs. We also use
Glyn Astill wrote:
> I'm not piping it to a file, postgres is managing the logs. Is there
> any way to manage the permissions, or do I just need to create a
> script to change the permissions?
I think you should be able to chmod the files after they have been
created. The postmaster changes its
On Thu, 2008-01-31 at 10:02 -0500, Chander Ganesan wrote:
> Magnus Hagander wrote:
> > On Thu, Jan 31, 2008 at 03:34:05PM +0100, Martijn van Oosterhout wrote:
> >
> >> On Thu, Jan 31, 2008 at 01:28:48PM +, Simon Riggs wrote:
> >>
> >>> That sentence has no place in any discussion about
On Thu, 2008-01-31 at 12:09 -0300, Alvaro Herrera wrote:
> > Simon Riggs wrote:
>
> >> As far as I am concerned, if any Postgres user loses data then we're all
> >> responsible.
>
> Remember, our license says this software is given without any warranty
> whatsoever, implicit or explicit, written
How I can recover data (or replicate data to another) based on
postgresql logs?
Where they are, and how I do it?
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining
I'm trying to install PostgreSQL 8.3 RC2 for Windows on my Windows
Vista Home Premium (Brazillian Portuguese), and thus I'm getting an
error on 'initdb' after copy of all files into destination path.
The error is this:
"Failed to run initdb: 1!
Please see the logfile in 'C:\Program Files\PostgreS
Hello List,
I am going to be setting up a warm standby postgresql 8.2.5 high
availability 2 server system. I was
wondering if anybody that has done this can share some scripts,
pertinent postgresql.conf entries,
etc so I don't have to reinvent the wheel. I have read the manual a
couple of time
Swaminathan Saikumar wrote:
http://searchyourwebhost.com/web-hosting/articles/insight-database-hosting-using-sql
Check out the link. I am starting out on a new personal project & had
zeroed in on PostGreSql with Mono-ASP.NET as ideal for my needs,
mainly owing to a PostGreSql whitepaper.
Now,
On 31 jan, 12:24, [EMAIL PROTECTED] ("Daniel Verite") wrote:
> T.J. Adami wrote:
>
> > I am also searching for a more 'professional' way to startup and
> > shutdown postgresql on ubuntu and debian systems.
>
> The source comes with a startup script that can be installed by
> running:
> # cp
Hi Adam,
Il giorno 31/gen/08, alle ore 16:13, Adam Rich ha scritto:
I'm trying to replicate the use of Oracle's 'lag' and 'over
partition by' analytical functions in my query. I have a table
(all_client_times) such as:
and I would like to create a new view that takes the first table and
calcul
T.J. Adami wrote:
> The source comes with a startup script that can be installed by
> running:
> # cp contrib/start-scripts/linux /etc/init.d/postgresql
> # update-rc.d postgresql defaults
> (update-rc.d is to debian-based systems what chkconfig is to
> Redhat-based systems).
>
> --
> D
hi, allow me to show-off my ignorance.. I think that logging via
'syslogd' and managing log files with 'logrotate' already meets the
requirements.
Alvaro Herrera wrote:
Perhaps we should add a log_file_group option, to which we would chgrp()
the log files.
regards, jr. ([EMAIL PROTECTED]
hi, allow me to show-off my ignorance.. I think that logging via
'syslogd' and managing log files with 'logrotate' already meets the
requirements.
Alvaro Herrera wrote:
Perhaps we should add a log_file_group option, to which we would chgrp()
the log files.
regards, jr. ([EMAIL PROTECTED])
hi, allow me to show-off my ignorance.. I think that logging via
'syslogd' and managing log files with 'logrotate' already meets the
requirements.
Alvaro Herrera wrote:
Perhaps we should add a log_file_group option, to which we would chgrp()
the log files.
regards, jr. ([EMAIL PROTECTED])
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 31 Jan 2008 18:13:53 +
jr <[EMAIL PROTECTED]> wrote:
> hi, allow me to show-off my ignorance.. I think that logging via
> 'syslogd' and managing log files with 'logrotate' already meets the
> requirements.
Unless you don't have access to
On Jan 31, 2008, at 10:21 AM, Alvaro Herrera wrote:
Glyn Astill wrote:
I'm not piping it to a file, postgres is managing the logs. Is there
any way to manage the permissions, or do I just need to create a
script to change the permissions?
I think you should be able to chmod the files after
Hi Willem,
> for some reason the order by's aren't working.
Could you provide more details? Do you get a specific error message?
> only returning 658 rows instead of the 750K.
You should not expect the same row count in both source table and
result set. Even in your example -- you provided 8
On Jan 31, 2008, at 10:14 AM, Erik Jones wrote:
That's an interesting idea. Is there a general audience/
participation wiki for Postgres? I know the developers have one,
but a user-oriented sister wiki would probably be a good way to get
lots of different people involved.
I'm of the opi
Hey Adam,
I tried your sequence method this morning on an unsorted table and for
some reason the order by's aren't working. If I create a sorted view
(client_id, datetime) on the 'all_client_times' table and then use that
view with your sequence method all works fine. The strange thing is
t
Hi all,
I've written a simple trigger function to store the old row in another table to
log the data:
CREATE FUNCTION logusers() RETURNS trigger AS $$
BEGIN
INSERT INTO log.users SELECT FROM data.users WHERE id=OLD.id;
RETURN NEW;
END;
$$ LANGUAGE plpgsql;
CREATE TRIGGER
On Jan 31, 2008, at 10:04 AM, Steve Clark wrote:
Hello List,
I am going to be setting up a warm standby postgresql 8.2.5 high
availability 2 server system. I was
wondering if anybody that has done this can share some scripts,
pertinent postgresql.conf entries,
etc so I don't have to reinven
On Jan 31, 2008, at 10:02 AM, T.J. Adami wrote:
How I can recover data (or replicate data to another) based on
postgresql logs?
Where they are, and how I do it?
See the chapters 23, 24 and 27 (at least) of the manual. For one
example of the process once you've read through all of that, see
The 'all_client_times' table has 753698 rows. The lagfunc() on the
sorted view returns 753576 rows and appears to work exactly as needed.
Using the function on an unsorted table returns only 686 rows and is
missing a whole lot of data. Running the count query returns 122 -
which is correct a
On Wednesday 30 January 2008 02:54, Ow Mun Heng wrote:
> On Tue, 2008-01-29 at 19:16 +, Dave Page wrote:
> > On Jan 29, 2008 6:16 PM, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> > > I try to be reasonable (no laughing people :)).
> >
> > Oh it's hard, so very, very hard!
>
> But seriously, I'v
Erik Jones wrote:
On Jan 31, 2008, at 10:04 AM, Steve Clark wrote:
Hello List,
I am going to be setting up a warm standby postgresql 8.2.5 high
availability 2 server system. I was
wondering if anybody that has done this can share some scripts,
pertinent postgresql.conf entries,
etc so I d
guys,
i got geometry in postgres, some other data in oracle. is it possible
to filter postgres geometry based on oracle data (without using
services)?
cheers, jzs
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Jan 31, 2008 1:38 PM, John Smith <[EMAIL PROTECTED]> wrote:
> guys,
> i got geometry in postgres, some other data in oracle. is it possible
> to filter postgres geometry based on oracle data (without using
> services)?
You either import the data from oracle to pgsql and let the db do it
(fastes
Ah, ok. I see what's happening. The data is retrieved from the tables,
and the sequence values are added, PRIOR to the order by, so that after
the order by, they are no longer sorted. (The same thing can happen
in Oracle with ROWNUM).
You can go the sorted view route, or just an inline view, l
On 01/02/2008, Tony Caduto <[EMAIL PROTECTED]> wrote:
> The part about the BSD license is bogus. A BSD license is the most
> desirable of any Open Source license and gives you the right to use
> PostgreSQL in your commercial apps without worry.
While I'm a big fan of the BSD license (for varied rea
Vivek Khera wrote:
>
> On Jan 31, 2008, at 10:21 AM, Alvaro Herrera wrote:
>
>> I think you should be able to chmod the files after they have been
>> created. The postmaster changes its umask to 0077, so no file is
>> group-readable. I don't think is configurable either.
>
> just move the logs in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 1 Feb 2008 10:04:53 +1300
"Andrej Ricnik-Bay" <[EMAIL PROTECTED]> wrote:
> On 01/02/2008, Tony Caduto <[EMAIL PROTECTED]> wrote:
> > The part about the BSD license is bogus. A BSD license is the most
> > desirable of any Open Source license an
Why doesn't the PL/Tcl (and PL/Python) implementation use the SPI functions?
For example pltcl_set_tuple_values() calls NameStr() instead of SPI_fname()
and heap_getattr() instead of SPI_getbinval(). Why? This makes the code
impossible to follow for someone who is not familiar with the postgres
Here is a little test example. It seems that the second order by
condition is not working - in this case datetime.
create table arb_test (
client_id integer,
arbnum integer);
insert into arb_test values (2,1);
insert into arb_test values (2,33);
insert into arb_test values (2,6);
insert into a
Robert Treat wrote:
Just so you know, I approached OReally about writing a PostgreSQL Cookbook,
and they turned it down. They did offer me some other titles, but those don't
seem to have gone anywhere.
As someone else pointed out in this thread, very much of what you need
to know has been p
fschmidt escribió:
>
> Why doesn't the PL/Tcl (and PL/Python) implementation use the SPI functions?
> For example pltcl_set_tuple_values() calls NameStr() instead of SPI_fname()
> and heap_getattr() instead of SPI_getbinval(). Why? This makes the code
> impossible to follow for someone who is n
Alvaro Herrera wrote:
Vivek Khera wrote:
On Jan 31, 2008, at 10:21 AM, Alvaro Herrera wrote:
I think you should be able to chmod the files after they have been
created. The postmaster changes its umask to 0077, so no file is
group-readable. I don't think is configurable either.
Hi there,
how can I dump a schema with all tables, but without the functions? Is
there a way to do it, or do I have to manually drop the functions
later when having used the pg_restore?
Thanks for any advice,
Stef
smime.p7s
Description: S/MIME cryptographic signature
"Andrej Ricnik-Bay" <[EMAIL PROTECTED]> writes:
> On 01/02/2008, Tony Caduto <[EMAIL PROTECTED]> wrote:
>> The part about the BSD license is bogus. A BSD license is the most
>> desirable of any Open Source license and gives you the right to use
>> PostgreSQL in your commercial apps without worry.
> how can I dump a schema with all tables, but without the functions? Is
> there a way to do it, or do I have to manually drop the functions
> later when having used the pg_restore?
Stef,
You can edit the data between dump and restore, to comment out the
function references. Or, you can use the "-
Stefan Schwarzer <[EMAIL PROTECTED]> writes:
> how can I dump a schema with all tables, but without the functions?
There's no built-in single command for that. You can accomplish it by
using pg_restore -l to make a list of objects, then edit the list,
then pg_restore -L to restore only the object
how can I dump a schema with all tables, but without the functions?
There's no built-in single command for that. You can accomplish it by
using pg_restore -l to make a list of objects, then edit the list,
then pg_restore -L to restore only the objects in the edited list.
Hmmm.. I probably sho
70 matches
Mail list logo
