We need to restore one table from a backup. What is the proper way to do this?
Our backup command looks like this:
pg_dump -C -Fc -S postgresql mydatabase today.backup.sqlc
I am using PostgreSQL 8.1.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
Hi,
We're trying to figure out why we're getting poor query performance on a
particular database running on a 64 bit Solaris box. The info for the poor
database is:
Red Hat Enterprise Linux AS release 4 (Nahant Update 2) Linux vl-sfv40z-001
2.6.9-22.0.2.ELsmp #1 SMP Thu Jan 5 17:11:56 EST
To all involved in this project,
I justed wanted to let you know how impressed and pleased I have been with
postgres over the past 5 years . The timeliness and quality of the releases
are always robust and stable. Every release has a very nice mix of admin,
performance, platform, and
Does anyone have any recommendations or
experiences on connecting a postgres db to a mysql db possibly through dblink
or another technology? Does dblink just do postgres to postgres? There is not
a lot documentation on that contrib.
Thanks,
Brian
weight_secondary to 0.
Did you mean Set weight_master to 0. Unfortunately this would not help
on a query by query basis, but the above would.
-Original Message-
From: Tatsuo Ishii [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 23, 2005 7:23 PM
To: Brian Maguire
Cc: pgsql-general
I have a couple Pgpool questions regarding running pgpool as a load balancer
with Sony as the replicator.
Is there anyway to load balance selects to more than 2 servers? ex. 1 master
with 2 slaves? Run multiple instances?
Is there any way to tell a select (ex. with a function) to go only
Has anyone ever used this? They have support for Postgres as
master or a slave in a heterogeneous setup.
Daffodil Replicator is a powerful Open Source data
synchronization tool that allows bi-directional data synchronization between
heterogeneous databases supporting JDBC drivers. Its
Is anyone currently using pgpool with production high volume use? I am
interested in your success and challenges.
Brian
Pgpool is a real cool project, I really hope it keeps evolving. I have a
couple basic/fundamental questions that I hoping to get some clarification on.
Question 1: If pgpool is used in conjuntion with slony or a another replication
it can be used only for its loadbalancing and failover. I am
Just as an FYI. Sun's Cache rowset which is new and part of the J2SE 1.5 is
not compatable with Postgres. We have been working with Sun's JAVA development
team to resolve the issues through our test cases and debugging. We hope that
in a future patch update that the issues will be resolved.
PM
To: Brian Maguire
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] what could cause inserts getting queued up and db
locking??
Brian Maguire [EMAIL PROTECTED] wrote:
We though there might be locking, but noticed that there were not any
queries in wait mode indicating that no statements were
Can too many btree indexes cause page level locking?
I read this
http://www.postgresql.org/docs/7.4/static/locking-indexes.html
The concern is the exclusive page-level locking that occurs
on inserts to the index.
I am experiencing locking related on two tables. Each
has
:[EMAIL PROTECTED]
Sent: Tuesday, October 26, 2004 4:46 AM
To: Brian Maguire
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] what could cause inserts getting queued up and db
locking??
Brian Maguire wrote:
What could cause the database to lock up and queue up all the
queries?
You'll want to check
Thanks. We do have it set to 15 mb. I would think that 16 mb would not
make a big difference. Do you have any other ideas?
-Original Message-
From: Kevin Barnard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 26, 2004 2:32 PM
To: Brian Maguire
Cc: [EMAIL PROTECTED]
Subject: Re
Background Info:
I have a table with a approx 2.5 million rows. The table often gets 200-300 inserts
per second. We are see that the database (7.4.1 Red Hat Enterprise ED 4 way Xeon)
will periodically lock up all of a sudden and force the database to queue up hundreds
of queries. The
Linux Magazine Feb 2004 published an article titled Postgresql 7.4: The
Database Administrator's Database. It is a 5 page article describing
in detail what and how to use the new postgres features such as
Expression indexes, arrays, data type domains, polymorphic functions,
and full text
Is support for tablespaces a priority feature for 7.5? I believe there
has been significant development in this area and it seems that
postgres' file structure opens it up nicely to support it. What are the
chances this will be completed?
In my opinion, it really is a critical feature to
Bugzilla is a good example PostgreSQL support. (Bug 98304
http://bugzilla.mozilla.org/show_bug.cgi?id=98304 )
http://bugzilla.mozilla.org/show_bug.cgi?id=98304 They only support mysql, want to
support postgres, and are tageting it in the next release, but might need a
nudge/support.
I am curious if tablespaces are going to be seriously targeted for the next version.
It really opens up new levels of scalability and is a killer feature from an
administration perspective.
Thanks,
Brian
---(end of broadcast)---
TIP 9:
And all along I thought v stood for victory we launched 7.4! Seriously huge
effort, great product, cheers! Another great milestone.
Cheers to the veam, I mean team.
-Original Message-
From: Peter Eisentraut [mailto:[EMAIL PROTECTED]
Sent: Mon
20 matches
Mail list logo