(assume this is ok because master has not been started yet)
> o Event Viewer, Administrative Events
> + Timed out waiting for server start up
>
> Any help, thoughts, comments, tips, etc would be greatly appreciated.
> Thanks!
> Dara
>
--
Chander Gane
possible on PostgreSQL?
Being a quite small company, proprietary hardware and fancy software
licenses are not possible (ie: 'use oracle' won't help).
I've looked at slony, but it looks more like a way to push
occasional copies to slaves, and isn't meant to be rea
Simon Riggs wrote:
On Mon, 2007-06-04 at 10:21 -0400, Chander Ganesan wrote:
It's not too hard to put together a "warm standby" synchronous
replication mechanism with overhead that isn't too much more than what
you incur by enabling PITR... Such systems can also have v
7;ve never tried to use it for such a thing (I've used it for
firewall redundancy in the past..which is what I think it was designed
for), but I'm fairly certain you could do so without too much trouble.
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morris
ndling pg_standby WAL file updates?
No. Though vacuums on the master would in effect also occur on the
standby node. So as long as you do vacuums on the master you'll be okay.
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
Phone: 877-25
uldn't expect AVD to kick off until after you did a mass
delete...assuming that delete was sizable enough to trigger a vacuum.
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
Phone: 877-258-8987/919-463-0999
http://www.otg-nc.com
Ask
a single list of roles (accounts
and groups) that span all of the databases that are managed by the cluster.
Hope that helps. When you read the documentation you will see
references to "Clusters", not databases...
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Sui
he backup.
However, you should keep in mind that - like a pg_dump - you won't be
able to perform PITR recovery from such a backup. Also, the recovery
time may be non-trivial depending on your WAL settings.
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisv
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 inconsisten
o that's not a pg problem)
Agreed. That's why I made it a point to mention that all of your
tablespaces should be on the same file system... In hindsight, I should
have also stated that your WAL logs should be on the same file system as
well...
--
Chander Ganesan
Open Technology Group,
allowing a script to be called with the log file name
after a log file is rotated. In such a case one could archive off
existing files, and since the switch to a new log file had already
occurred, also change permissions, etc if needed.
--
Chander Ganesan
The Open Technology Group
One Copley
e working with
heartbeat? is that recommendable?
Yes. However your configuration could lose transactions in the event of
a crash of the primary (assuming you can't access its pg_xlog directory
after the crash). If you're using heartbeat then you probably have the
two servers relat
Simon Riggs wrote:
On Sat, 2008-02-09 at 07:49 -0500, Chander Ganesan wrote:
Signalling components could be added to pg_standby at some point...
What sort of thing are you looking for?
pg_standby accepts a trigger file as well as various types of signal
I didn't see anything
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
919-463-0999/877-258-8987
http://www.otg-nc.com
---(end of br
ssion into the mix and I think you could find that there are
little/no similarities..
On the other hand, if you were only doing inserts into an optimized (no
dead tuples) table, I would think that you'd get a much better result.
Perhaps you would be better off using PITR in such cases?
Hello,
I'm trying to build 64-bit PostgreSQL with gcc 4 on the solaris platform
- this worked fine with gcc3, but the error below seems to come up with
gcc4 . has anyone seen it before (or does anyone have a quick solution
for it?)
gmake[3]: Entering directory
`/src/postgres/postgresql-9.1
less you or autovacuum has done a
recent ANALYZE ... Also keep in mind that in PostgreSQL, a count(*)
will actually do a table scan, and could be time (and I/O) consuming if
you are looking at a large table.
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisvi
neous, but they still must be done).
You might consider using rsync instead, it should be a lot faster than
tar, and doesn't have the same downside as using snapshots. You'll also
find that it is fairly widely used in the PostgreSQL community.
--
Chander Ganesan
Open Technology Gr
r not have to "roll my own" if possible.
thanks
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
919-463-0999/877-258-8987
http://www.otg-nc.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
I thought at one point there
was an issue with the windows socket implementation that made it less
than ideal...but that might have been a long time agodoes anyone know?
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
919-463-0999/877-258-
or you
(if you want synchronous HA) is to get another 64 bit system for your
secondary, or even install a 32 bit OS on your 64 bit system, so you
have 2 32 bit systems. In which case you'd probably want to add DRBD in
to the mix for your active WALs..
--
Chander Ganesan
Open Technology Gr
reate a warm-standby backup and then log subsequent WAL files to ease
future recovery from WAL's on the "currently active" cluster.
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
919-463-0999/877-258-8987
http://www.otg-nc.com
ar pg_total_relation_size() , |pg_size_pretty|(), and the
like... Seems much more straightforward than the queries mentioned above..
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
919-463-0999/877-258-8987
http://www.otg-nc.com
Ask me about ex
space padding stored in a char field - which takes up extra
space).
Keep in mind that by limiting the size you can also prevent things like
TOAST from being used (alternately, you could set the storage type on
the column to prevent TOAST).
Chander Ganesan
Open Technology Group, Inc. - Expert
nt WAL log replication (in 8.2 or
otherwise) would allow you to have a 'warm standby' type database -
which would be somewhat in sync (pending the latest transactions), but
would be unable to service queries (essentially, you'd have a server
that was sitting with postmaster in a
vides Oracle compatibility...
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
Phone: 877-258-8987/919-463-0999
---(end of broadcast)---
TIP 4: Have you searched our list archives?
be relatively easy to
do the conversion. If you did not, then it could be time consuming
(though not overly difficult).
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
Phone: 877-258-8987/919-463-0999
thanks in advance,
Ganbold
--
t the quality
of content of the courses that we offer.
Our Morrisville, NC PostgreSQL courses are also guaranteed to run -
regardless of the number of students that enroll. So you can base your
project schedules/plans on the fact that you will get the training when
you schedule it.
Thank You
-
ore students in them. We've run (and
continue to run) occasional PostgreSQL classes with 1 or 2 students. We
maintain a class "A" facility with the latest in hardware and a single
PC per student - so everything is hands on, and students are able to
exercise pretty much every thin
occur, otherwise you could
be returning rows that don't satisfy the join condition.
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
Phone: 877-258-8987/919-463-0999
http://www.otg-nc.com
Expert PostgreSQL Training:
http://www.otg-nc
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/09/07 07:28, Chander Ganesan wrote:
Ron Johnson wrote:
On 01/08/07 20:39, Tom Lane wrote:
John Sales <[EMAIL PROTECTED]> writes:
By doing this, I'm hoping that the query optimiz
provides training - our PostgreSQL
Performance & Tuning course covers the installation and use of
pgmemcache, as well as numerous other performance related topics.
http://www.otg-nc.com/training-courses/coursedetail.php?courseid=47
--
Chander Ganesan
The Open Technology Group
One Copley Pa
training in Australia. You
might give the folks at Fujitsu Supported PostgreSQL Australia a call.
Their web site is:
--
Chander Ganesan
The Open Technology Group
One Copley Parkway, Suite 210
Morrisville, NC 27560
Phone: 877-258-8987/919-463-0999
http://www.otg-nc.com
prematurely...
The web site for Fujitsu Australia is: http://www.fastware.com.au/index.html
I know I've seen them offer PostgreSQL training in the past, and I'm
sure they do/will in the future (if not, the US is always a nice place
to visit... :-) ) .
--
Chander Ganesan
The Open Techno
http://www.postgresql.org/about/licence
The short of it:
Permission to use, copy, modify, and distribute this software and its
documentation for any purpose, without fee, and without a written
agreement is hereby granted, provided that the above copyright notice
and this paragraph and the followi
ablespace names as
needed...
I apologize if this has already been mentioned/suggested :-)
--
Chander Ganesan
The Open Technology Group
One Copley Parkway, Suite 210
Morrisville, NC 27560
Phone: 877-258-8987/919-463-0999
http://www.otg-nc.com
Tom Lane wrote:
Chander Ganesan <[EMAIL PROTECTED]> writes:
I'd like to suggest that a feature be added to pg_dumpall to remove
tablespace definitions/creation from the output. While the inclusion is
important for backups - it's equally painful when attempting
Florian G. Pflug wrote:
Chander Ganesan wrote:
Tom Lane wrote:
Chander Ganesan <[EMAIL PROTECTED]> writes:
I'd like to suggest that a feature be added to pg_dumpall to remove
tablespace definitions/creation from the output. While the
inclusion is important for backups - i
, the OLD record will
contain the information pertaining to the record being deleted.
http://www.postgresql.org/docs/8.1/static/triggers.html
You might also take a look at Slony-I, since it does something similar
with INSERT UPDATE and
DELETE triggers - it stores the information that has changed s
up... You'd still have some of the pgpool
shortcomings (most notably things like 'select nexval()' type statements
and lack of secure authentication...but wouldn't suffer from data loss
in the case of a failure.
--
Chander Ganesan
Open Technology Group, Inc.
One Copley
ok at the PostgreSQL documentation for function-based indexes.
select from ... where
simplify(url) <> url_col;
In the example above 'url_col' would have a function-based index that
was based on 'simplify(url_col)'
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkwa
41 matches
Mail list logo
