On 08/12/2013 08:28 AM, David F. Skoll wrote:
Hi,
We run a fairly write-intensive workload and are looking at upgrading
our Pg servers. (PostgreSQL 9.1; no practical way to upgrade to 9.2 for
a while because we use what's packaged with Debian.)
apt.postgresql.org
I'm considering the foll
On 7/15/2013 8:55 AM, Jorge Torralba wrote:
I have a master and a slave running streaming replication between the
two servers. I would like to setup some kind of third machine to play
the role of observer node to monitor the replication and do the
automatic fail over. However, I can't find an
On 06/14/2013 01:47 PM, Andreas wrote:
Am 14.06.2013 20:55, schrieb Peter Geoghegan:
On Fri, Jun 14, 2013 at 11:55 AM, Andreas wrote:
How can I get more memory for PG on openSUSE 12.3 ?
http://www.postgresql.org/docs/9.2/static/kernel-resources.html
OK I think that did it :)
I'm just
On 06/07/2013 09:37 AM, Ray Stell wrote:
Is Postgresql-XC being used far-and-wide in production? It looks like an
attractive path for a problem I'm considering, that problem being close to zero
downtime with data replicated to all the datanodes. I suspect that is not the
primary purpose of
On 05/16/2013 01:36 PM, Victor Tan wrote:
I am basically familiar with postgreSQL (in older incarnations) but have
not really done a streaming replication (WAL) setup before.
In planning for my setup, I am going to use table partitioning and
tablespaces to keep things as quick as "possible". H
r.
The mailing list that Craig is speaking of is pgsql-jobs and you are
probably better off posting there.
Good luck to you,
Joshua D. Drake
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
& only one "postgres" superuser,
which is its home dir, or does it matter?
Doesn't matter.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversi
On 07/26/2012 12:31 PM, Gary Webster wrote:
OK, I set "log_statement = "all""
The log grew to 1GB in ~minute! It is dominated by this one statement,
which occurs every ~1.4 sec:
"update WS_BUNDLE set BUNDLE_DATA = $1 where NODE_ID_HI = $2 and
NODE_ID_LO = $3"
parameter $1 is hex, over 6million
On 07/25/2012 11:37 AM, Gary Webster wrote:
This is a cluster issue, not a database issue. So if you have an
idnle in transaction, then it is affecting your JCR schema as well.
OK, how do I track/debug/stop the "idle in transaction"s ?
Well idle in transaction is ALWAYS a code issue.
to need to install some HAC components, such as
pacemaker/corosync and automate the base backup creation for the old
master. It is not complicated but it is comprehensive.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training
On 07/24/2012 08:58 AM, Gary Webster wrote:
Hello.
Thanks for the response.
There are several 'idle in transaction' on this server/app, but to a
different db/schema.
This is a cluster issue, not a database issue. So if you have an idnle
in transaction, then it is affecting your JCR schema as
If you do,
you have a code problem not a postgres problem and it is presenting
itself through bloat.
Note: IDLE is fine. It is specifically IDLE IN TRANSACTION that is a
problem.
Sincerely,
Joshua D. Drake
Thanks.
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Su
ok at tablelog for auditing. It automates it.
Syslog is not really a good way to handle that.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference -
On 10/05/2011 04:34 PM, Ben Ciceron wrote:
has anyone a positive experience using pg9.x streaming replication over WAN ?
It is no different than the innertubes. Just make sure you have enough
bandwidth and the proper ports directed via firewall/vpn.
JD
Cheers,
Ben-
--
Command Prompt
On 08/11/2011 07:57 AM, CS DBA wrote:
On Thu, 2011-08-11 at 08:41 -0600, CS DBA wrote:
Anyone know of tools / options that will allow Oracle to PostgreSQL
replication? or at least a real time feed or dblink?
EnterpriseDB's Postgres Plus Advanced Server has a realtime replication
solution bund
The other two servers are configured identically. If I diff the
configuration files, the only difference is the IP addresses for the
"listen" section.
Can anyone tell me what's going on? Why is pgstat.stat being rewritten
on this server constantly and not on the other two servers?
Do you have
On 04/24/2011 03:21 PM, David Hornsby wrote:
My SMB database is currently running on a HP-UX box running in a master
- slave slonyI cluster to create a hot spare database. Recently the
server has be getting hammered and we are consistently hitting our max
db connections. We have our web CMS and o
On Mon, 2011-03-14 at 20:04 -0700, H S wrote:
> Kevin,
>
> What did you mean by "OP"?
It means "Original Poster"
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.
On Wed, 2011-03-02 at 23:44 -0500, Robert Treat wrote:
> Yeah, it's worth pointing out that either you (the OP) are reading the
> wrong stuff, or interpreting it wrong. 25% is usually where people
> will tell you to start, and then tune it *down* (change, measure,
> asses, repeat).
assess robert.
On Wed, 2011-02-16 at 15:56 -0500, Greg Smith wrote:
> Bryan Keller wrote:
> > It sounds like NFS is a viable solution nowadays. I a still going to shoot
> > for using iSCSI, given it is a block-level protocol rather than file-level,
> > it seems to me it would be better suited to database I/O.
>
On Mon, 2010-11-22 at 03:09 +, Lou Picciano wrote:
> Really? Wouldn't it be good general practice to store the xlogs on a
> different filesystem - offering one further layer of protection, if
> you will? L
Best practice is to move the xlogs to another filesystem but not for
protection (that i
't have an
idle-in-transaction problem).
> pg_stat_user_tables have only the cumulative stats. I am interested in
> finding the most current ( incremental stats).
Pg doesn't provide this by default, you would have to install mrtg etc..
Joshua D. Drake
>
> Thanks a lot.
bles etc.
>
> I think of something like
> REVOKE ALL ON SCHEMA pg_catalog FROM PUBLIC
> REVOKE ALL ON SCHEMA information_schema FROM PUBLIC
>
> but I am not sure about consequences and I did not find any useful
> information in manual.
That's cause its a bad idea.
On Fri, 2010-10-29 at 10:03 -0400, Tom Lane wrote:
> Dragos Valentin Moinescu writes:
> > The thing is that I cannot catch the exception raised by plpy.execute().
>
> Yeah, plpython's error handling is fundamentally broken. Somebody
> needs to rewrite it to be more like the other PLs. In the me
On Tue, 2010-09-21 at 13:32 -0700, Benjamin Arai, Ph.D. wrote:
> Hello,
>
> The server is still running but pg_dumps output the following error.
> What should I do?
Try reindexing the index.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Promp
On Tue, 7 Sep 2010 15:03:44 +0200, fel wrote:
> Hi all,
>
> I am working on upgrading my hardware and wondering how Postgres could
> work with SAN, NAS and DAS .
> Can someone advise me or share experiences ?
Unless you want to spend *A LOT* of money, DAS is the way to go. You can
get quite a b
aps thinking about it like this will help:
(major.major).(minor|maintenance)
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/
On Sat, 2010-08-28 at 17:25 +0200, David Montoya wrote:
> Hello:
>
>
> I have a DB with 90GB in postgre 8.1 and I want to move to another
> server. The new server has postgre 8.3 and I don't know if I can use
> PITR to do the replication.
You can not.
Use Londiste or Slony.
JD
--
PostgreSQL
ctual business requirements. I tend to prefer DAS
but a good SAN or NAS (iSCSI) configuration works well. I personally
would avoid anything that is just a network mount like NFS or CIFS.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.
On Wed, 2010-08-25 at 22:39 +0300, Dragos Valentin Moinescu wrote:
> What I did in terms of warm standby:
> 1. base backup using rsync
> 2. rsync all wal files
> 3. edited recoverfy.conf with a recovery_command="cp /wal-archive/%f %p"
>
> So I need to write a new recovery_command that actually pr
Slony (or Londiste) can handle that without issue, at all.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/comm
On Mon, 2010-08-23 at 14:38 +, Kieren Scott wrote:
> Hi,
>
> I have a web-based application (drupal) which uses PHP to make
> connections to a back-end postgresql 8.3 server. The application and
> database are on separate servers, but as we can get 20+ concurrent
> connections on the database
g actions, such as
> connecting to another database?
That is called logging. Just turn it on :D
> Can't build a trigger on a function call, right? Has to be based on
> a data change?
A trigger is based on data modification, yes.
Joshua D. Drake
>
>
> Tks in a
On Tue, 2010-07-27 at 14:16 -0400, steve.tout...@inspq.qc.ca wrote:
>
> Thanks Kevin,
> Which of these 2 methods is the best practice?
>
> It is working with pgpass.
> But not yet with hba.conf
> I tried this without success.
> hostall all 127.0.0.1/32 trust
>
On Tue, 2010-07-27 at 14:03 +, ALEXANDER JOSE wrote:
> I wonder if anyone has experience in installing postgresql on windows
> 7 that is the most appropriate version?
http://www.postgresql.org/download/windows
8.4.4
>
>
>
> Atentamente
>
> Alexander Angel
> Venezuela
>
>
> _
e testing on v9 beta or not. It works as documented on
the other versions. The language is used by people, most of the reports
we get are build errors not crashes or other oddities.
It is available from GitHub:
http://github.com/cmdpromptinc/PL-php
Sincerely,
Joshua D. Drake
--
PostgreS
On Tue, 2010-07-20 at 13:20 -0300, Fábio Gibon - Comex System wrote:
> Hi everybody,
> are there how define autovacuum to ON and define the period
> time (for example, 00h - 06h) that it's can run?
>
No. You would need to write your own job manager (or use one of the many
that already ex
On Thu, 2010-07-15 at 11:49 -0700, Craig James wrote:
> I'm migrating from Postgres 8.3.10 to 8.4.4, and also from Fedora 9 to Ubuntu
> 10.04.
>
> On 8.3.10, I have a C extension that worked on 8.3, but now refuses to load
> on 8.4:
>
> CREATE OR REPLACE FUNCTION chmoogle_session_id() RETURNS i
3919352k total, 5792k used, 3913560k free, 3178548k cached
Which means exactly nothing, unless that SWAP number starts churning.
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support,
ake
again in a different format, use -Fc and then use parallel restore. Even
if half of the database is one table, you will still knock the restore
time by 50% or so.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consu
On Fri, 2010-07-09 at 15:31 +0200, Henry, Frank wrote:
> Hello everyone,
>
> We had a problem with one of our servers and had noticed that the
> postgres/8.3/main folder had become quite large (>650mb).
> PostgreSQL confirmed this via a query but when I queried the size of the
> tables I was barel
n.
Sincerely,
Joshua D. Drake
> >
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes t
obody should be able to directly log
> into it. Do you think that will cause problems?
You should treat the postgres account like root. In reality nobody
should be logging in as postgres on the OS except for extremely specific
purposes.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
C
On Fri, 2010-06-25 at 06:31 -0700, Bob Lunney wrote:
> I'm not sure if this is really a bug, so I'm posting here instead of
> pgsql-bugs.
I am thinking this needs to be posted to:
http://lists.slony.info/mailman/listinfo/slony1-general
JD
--
PostgreSQL.org Major Contributor
Command Prompt, In
On Sat, 2010-05-22 at 09:51 -0400, Doug Gorley wrote:
> From what I see in the docs, these three settings in postgresql.conf
> should be enough for PostgreSQL (8.2) to autovacuum with the default
> settings:
>
> autovacuum = on
> stats_start_collector = on
> stats_row_level = on
>
> So, two quest
p effectively makes every incremental backup a
> full backup which is a great time-saver during recovery.
We accept patches, donations and sponsorship opportunities :)
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consultin
ostgreSQL checks for that.
Either way, if you actually managed to start two services against the
same data directory, I hope you have a backup, you can restore from.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting,
On Fri, 2010-04-30 at 18:51 -0400, STEVE NAYAM wrote:
> Hello
>
You want to post to pgsql-jobs
>
>
> This is Steve Nayam from MRS. I am looking for Postgresql DBA
> consultant.
>
> I just want to know if you can help me in this regard, can I post jobs
> here.
>
>
>
> Thank you
>
>
>
rn CA. So anything closer to LA will be convenient and
> preferred.
EntperiseDB offers some great Web based training...
Joshua D. Drake
>
> There is lots of information on web, but any word from this lists will
> have lot more weight.
>
>
>
> Thank you,
>
&
On Tue, 2010-03-09 at 15:43 -0600, Kenneth Marshall wrote:
> On Tue, Mar 09, 2010 at 01:28:20PM -0800, Joshua D. Drake wrote:
> > On Tue, 2010-03-09 at 14:25 -0700, Scott Marlowe wrote:
> > > On Tue, Mar 9, 2010 at 2:06 PM, Joshua D. Drake
> > > wrote:
> > >
On Tue, 2010-03-09 at 14:25 -0700, Scott Marlowe wrote:
> On Tue, Mar 9, 2010 at 2:06 PM, Joshua D. Drake
> wrote:
> > On Tue, 2010-03-09 at 13:35 -0700, Scott Marlowe wrote:
> >
> >> > In a nutshell, I am heartly recommending virtualization.
> >>
> >
's still a real one.
>
Not luck. Percentage of risk.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Respect is earned, not gained through arbitra
trtools to manage
this. Walmgr is part of skytools, pitrtools can be found here:
https://projects.commandprompt.com/public/pitrtools
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom De
On Mon, 2010-01-18 at 13:41 +, Renato Oliveira wrote:
> Julio,
>
> Unfortunately our live system runs 8.2.4 and it is quite tricky to
> upgrade it right now.
>
>
>
> By the way where can I find a how to use pitr-tools?
https://projects.commandprompt.com/public/pi
; why Centos has this old version by default).
Get off 8.1.18, use www.pgsqlrpms.org.
You want AT LEAST 8.3.
Also, make your life even easier:
https://projects.commandprompt.com/public/pitrtools
Joshua D. Drake
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting,
B
>
> We have 8GB of RAM
>
> 300GB Hard disk Raid1
>
> Everything is within a single Volume
>
>
>
> Today the load average was as high as 15
Linux?
Are you using elevator=deadline?
How many spindles, what type of raid?
Are you doing proper maintenance?
Joshua
On Mon, 2009-12-14 at 23:21 -0500, Scott Mead wrote:
> On Mon, Dec 14, 2009 at 10:32 PM, Net Tree Inc.
> wrote:
>
>
>
>If you need to block access, you can use the host based access file
> (pg_hba.conf).
> http://www.postgresql.org/docs/current/interactive/client-authentication.ht
On Mon, 2009-12-07 at 13:29 -0500, Adam Tucker wrote:
> I'm interested in having live replication from one server to another, and
> I've looked into many of the options out there but I'm unclear on one part of
> it. The way our database works is that each individual user account has
> their own
On Thu, 2009-11-19 at 18:53 +, Julio Leyva wrote:
> check this
> http://symmetricds.codehaus.org/
>
> I just began playing with that one
>
>
> > Date: Thu, 19 Nov 2009 12:39:04 -0600
> > From: kevin.gritt...@wicourts.gov
> > To: pthiyagara...@cashedge.com; pgsql-admin@postgresql.org
> > Sub
On Thu, 2009-10-22 at 17:41 -0600, Kevin Kempter wrote:
> Hi all;
>
> Anyone know how to select / calculate the actual data size for a table or
> index?
select pg_total_relation_size('relation')
>
> NOT the disk usage as in:
> pg_class.relpages -- shows disk usage including bloat
> pg_relat
gt; > the new current timeline, or complain about being in the older
> > timeline? Do I have to take another full backup of Server B after
> > it's become the production/provider node?
You will need to do a new base backup.
Joshua D. Drake
> >
> > Thanks,
>
On Wed, 2009-10-21 at 17:39 -0700, Tena Sakai wrote:
> Hi everybody,
>
> Is it possible to have psql ignore the line I am typing?
> That is, similar to '#' with unix shell. What I would
> like is to document my interaction with psql. If an
> exclamation mark were a comment character, I may type
On Thu, 2009-09-17 at 12:06 -0600, u235sentinel wrote:
> Not sure if this is the right list but here goes.
>
> I have gnu gcc and make on a Solaris 10 AMD64 system and having a bit of
> a problem compling postgres 8.3.7 with openssl. I've even tried with a
> newly compiled version of openssl.
ld retrieve a
> history of this particular thread?
>
> Thank you in advance
http://archives.postgresql.org/
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
and there isn’t one that I can find
> so I am wondering if it is a persistent connection and if it is how do
> I kill it? Will restarting the server drop the connection
Yes restarting the database will drop the connection.
I guarantee you, you have a pg_hba.conf somewhere.
Joshua D. Drake
>
rsion.
http://www.postgresql.org/docs/8.4/static/release-8-4.html
Note you will need to read the release notes for each version to
determine differences that may affect you. The one that will likely hit
you the worst is the removal of implicit casts in 8.3.
Joshua D. Drake
>
--
Postgre
On Wed, 2009-07-01 at 16:11 -0400, Mark Steben wrote:
> Great to see the announcement of the 8.4 rollout. Quick question - is hot
> standby available or still being worked on?
It is not in 8.4. The hope is to have it for 8.5.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgres
On Fri, 2009-05-08 at 10:19 -0400, Ray Stell wrote:
> On Thu, May 07, 2009 at 09:58:04AM -0700, Joshua D. Drake wrote:
> > Because "users" shouldn't compile. The commands aren't relevant. If
> > possible you should *always* run from your package manager.
>
uld I have to configure a custom init.d script so my
PostgreSQL will start?
I can go on, and on, and on...
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The Postgre
ing issues with xlogs deletion waiting to
> blow my foot off.
>
What version of PostgreSQL is this? 8.2+ should shut down proper without
issue. 8.1 does have issues.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-
3463991
> 2832506
At this point you may be better off just doing a backup and restore and
then figure out why your maintenance routines are failing.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http:
gt; database under /usr/local/bin and by using RPM only.
They are wrong. Redhat standard is /usr/bin for
binaries /var/lib/pgsql/data for the data directory.
Use www.pgsqlrpms.org and make your life easy.
Joshua D. Drake
Joshua D. Drake
>
--
PostgreSQL - XMPP: jdr...@jabber.postgre
ow about from a developers position - most of our code accessing
> the databases is jboss/java/jdbc. What could have happened from the
> code side that caused these uncommitted transactions?
The use of XA/two phase commit transactions that assume rollback on
disconn
On Tue, 2009-04-21 at 11:13 -0400, May, Randy wrote:
> PostGresQL Admin,
>
This is more of a hackers discussion. I am forwarding there.
-Hackers,
Do we have a history on this file?
Joshua D. Drake
>
>
> I am part of an organization that is beginning to write commercial
>
> must be vacuumed within 982038 transactions
> 2009-04-20 11:37:47.377 EDT [8513] [] HINT: To avoid a database
> shutdown, execute a full-database VACUUM in "postgres".
>
> trying to restart the server - I still am getting the same initial
> err
ostgresql (probably things like psql) but I
can tell you that without postgresql-server, you aren't going to get
very far :)
In short you likely need both.
Joshua D. Drake
>
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Trai
s like you were cut off a bit. What do the logs say and your ps
output on the standby?
Joshua D. Drake
>
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving sin
On Thu, 2009-02-26 at 12:17 -0600, Scott Whitney wrote:
> So, I got pretty close to my max_connections setting, and I had to up it
> last night. I did so, and I issued a pg_ctl reload. Everything _seems_
> happy.
>
> However, the script I use to monitor this has the number hard-coded in it
> (well
ort.
You need zlib-devel.
Is there are particular reason you aren't just using the precompiled
RPMS for 8.3.6?
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL C
e.
> I don't know if I'm looking in the wrong place or he dropped them
> after the table was created.
It will show per database. So if you want to see his, connect to his
database.
Joshua D. Drake
>
> Carol
>
>
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
; is over:
cmd_standby -B (base backup)
cmd_standby -S (standby mode)
cmd_standby will use rsync to make your base backup so it only copies
what has changed.
https://projects.commandprompt.com/public/pitrtools
It is BSD licensed.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.o
to manage this. I would also suggest just restoring as the
logs become available. If you can't process 2G in an hour over the
network do it at night.
Joshua D. Drake
>
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - htt
.
And with that note, I believe we should all agree to go back to whatever
corner you prefer and stop this thread :).
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQ
down for you.
No.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To
On Wed, 2009-01-28 at 12:38 -0600, Scott Whitney wrote:
> Wow. This just boggles my mind, but there it is. Here's Oracle:
>
This looks like a NULL vs '' issue. Am I wrong?
Joshua D. Drake
> SQL> select i from a1;
>
> I
>
> o
lopment rpms? or source?
>
Take a look at http://www.pgsqlrpms.org
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-admin mailing
s on how to resolve
> this problem will be highly appreciated.
We need more information on what your script is actually doing. Are you
calling pg_start_backup before you do the cp? (also you really should
use rsync).
Joshua D. Drake
>
>
> Thanks
> Paramjeet Bhella
>
>
--
Postgre
e network becomes an issue - 12 - 13 hours at best.
> If we have to do this then we will. I just want to make sure I'm
> understanding your advice.
Yes.
Joshua D. Drake
>
> Thanks
>
> Mark Steben│Database Administrator│
> @utoRevenue-R- "Join the Revenue-tion
> this situation? Pg_resetxlog perhaps?
>
How did you do that? What are you using to copy the logs? You may want
to look at pitr tools. It will make your life easier:
https://projects.commandprompt.com/public/pitrtools
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Su
On Mon, 2008-12-01 at 21:35 -0700, Kevin Kempter wrote:
>
> Hi All;
>
> I wonder is there a way to force autovacuum events to be logged to the
> postgres log ?
I believe they are, if you turn it up to DEBUG or DEBUG2.
Joshua D. Drake
>
>
> Thanks in advance
>
-
f the server failed to come up, you won't get a connection at
all, if you try to connect and you are able to connect but not initiate
a session and appropriate response will be sent.
Joshua D. Drake
--
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On Tue, 2008-05-20 at 17:57 +0400, pronix pronix wrote:
> hello
> how i can restrict dbusers ( user's db size, cpu time)?
You can't within PostgreSQL.
Joshua D. Drake
--
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your su
Aftab Alam wrote:
Yes ,I want a replica of my db so that I can use it as failover
Version 7.3 linux AS release 4 update 6
Version 7.3 is end of life and I don't know of *any* of the replication
technologies that will work with it.
Joshua D. Drake
--
Sent via pgsql-admin mailing
old one. E.g;
this will be an outage, you can not do it online (without something like
SlonY0.
Sincerely,
Joshua D. Drake
>
> Thanks again.
>
>
> Chris
>
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.pos
Your problem is likely the -c not the -O. In your target database you
have a role that owns objects. You can't drop a role if it owns objects.
Joshua D. Drake
>
> Marc
>
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://w
me where I can go
to grab the correct set of files to upgrade to the latest
postgres, v8.3.3?
I have been to the postgres website and via File Browser, I got to:
Top ? binary ? v8.3.3 ? linux ? rpms ? redhat ? rhel-4-x86_64
Am I at the right place?
Yep.
Joshua D. Drake
Please advise.
Many
in which all data is stored.
- If I restrict the size of this directory then by database size will be
automatically controlled.
And you might possibly corrupt data when you hit the barrier.
Joshua D. Drake
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your
itoring the standby database. Any suggestions or help will
> be highly appreciated.
If you set the logging to debug2 in the postgresql.conf on the standby,
it will tell you what logs are being restored as they are restored.
Further pg_standby will tell you in the process list.
s?
If the table has oids, pg_dump is going to grab them and restore them as
such. If you are assured that you don't need OIDs I would drop the oid
columns from the user tables before the upgrade.
>
> 2. Alter encoding from C to utf8.
Very good chance the dump will not load without g
e if it bloated out. What you
are best to look at is the type of queries are being run. Determine what
is getting bloated and look at modifying how you maintain that relation.
7.4.19 (which hits soon)
Joshua D. Drake
>
> Regards,
> Devendra
>
> Devendra Singh Rawat
> Infosys Tec
1 - 100 of 363 matches
Mail list logo
