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 never
[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.
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
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
zones
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 much harder to
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
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 working
[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
---(end of
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 constantly
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. But what is
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 that
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 be
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 I
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
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? Or am I
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 the
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 them so they can
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 from
--- 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.0 there is
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
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 so that
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 only
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
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
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 backup because
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 or implied,
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
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
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
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
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).
--
Daniel
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
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
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
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
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
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've ranted on
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
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
(fastest),
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,
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
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 into a
-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 and gives
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
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
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
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 not
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.
While I'm a
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 -L
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 objects
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
70 matches
Mail list logo
