I'm trying to dump a table in PostgreSQL , it's PostGIS data, and is
quite wide...I've checked the ulimit settings and verified they are
unlimited for memory related settings.
I get this whenever I try to do a pg_dump. Curiously, if I *decrease*
shared buffers wy down, I find that these e
With PostGIS 2.0 if I load/install postgis using the command:
create extension postgis schema postgis;
And then use the command:
pg_dump -t postgis.spatial_ref_sys dbname > spatial_ref_sys.sql
I get an output that contains a few "set" statements, but no table
definition or data from the table
Hi All,
I'm running into a weird issue with PostgreSQL 9.1.3 and PostGIS 2.0
when trying to dump a table - no matter what table I try to dump in this
database, I find that I get the same error, as evidenced below (scroll
down for relevant data/error output.)
Any ideas as to what might be the
erly.
Did you make sure that you made the appropriate changes to
postgresql.conf and pg_hba.conf on the new system to ensure that users
will be able to connect over the network?
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
919-463-0999/87
quot; that include the cost of
airfare and hotel accommodation...
We also offer on-site training that's affordable for groups as small as
3 people.
Let me know if you'd like more information...
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC
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
ty mechanism to
retain your old database versions. I suppose you just have to be
careful to make a copy of the cluster before trying to start it up (lest
you break an older or newer backup).
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
919-463-09
ent out the line) in your
postgresql.conf and remove any 'hostssl' lines from your pg_hba.conf
file. That will effectively disable SSL. IIRC There's really no need
to rebuild/reinstall anything..
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville,
g for jobs are likely subscribed to and
monitoring that list, and might not monitor this one. This list is for
database administration related questions.
Please post to the appropriate list in the future.
Thank You
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suit
what you were trying to accomplish we could provide you with a
suitable solution that doesn't require a restart...
--
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
Expert PostgreSQL, PostGIS,
Essentially making your "old" backup an incomplete backup
of your new cluster.
In essence, a "hard link" isn't a copy of any sort, it's just a pointer
to the same inode, which is the exact same data...
Perhaps there is something that I am missing here?
Thanks
-
by tools such as Navicat, since those
tools fully qualify the name of all database objects (i.e.,
public.tablename, etc.) . Doing so is not required (unless you've
changed the default search_path in your postgresql.conf file) if you
aren't using any special schemas, etc.
--
Chander
that deal with the version of PG that
you have. There have been some changes (mostly related to continuous
PITR) changes in post 8.1 releases...
--
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
using the commands:
sync
echo 1 > /proc/sys/vm/drop_caches
That's likely what you are missing.
--
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
Expert PostgreSQL, PostGIS, MapServer, Python
you call pg_fetch_assoc($result) the result set is advanced
to the next row of results, so you shouldn't use this unless you want to
actually process a row of results...
Generally speaking, you might have an easier time of interfacing with
the database if you use an abstraction layer li
Jaume Sabater wrote:
Chander Ganesan wrote:
If you are running warm-standby, its presumable that your standby
server is "consuming" these files as they are being generated. In
such a case, you can set "log_restartpoints" in your recovery.conf
file, and use pg_
27;true'
restore_command='pg_standby /archive_dir %f %p %r'
In short, your system that is in "recovery mode" can decide which ones
it needs to get rid of, once it knows it no longer needs them.
Note: I believe the log_restartpoints option (and %r argument) were
ad
Tom Lane wrote:
Chander Ganesan <[EMAIL PROTECTED]> writes:
You should also understand that if you set checkpoint_segments to a
small number, its still possible that PostgreSQL might use more than
that number for a large transaction.
"Large transactions" have nothing
about limiting
the space available to your xlogs, lest it cause transactions to fail
due to insufficient space for the xlogs.
--
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-admin
would allow you to achive durability of committed
transactions. I'll actually be talking a bit about this at the PGDay of
Linux World (August 5th)...
--
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
A
PAM.
However, I don't think that the native mechanism will allow you to do
what you are trying to accomplish.
--
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
raint exclusion.
--
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 OTG's Expert On-Site & Public enrollment PostgreSQL, PostGIS, and
other Open Source courses.
check your application code to ensure that it's handling error
messages on insert failures correctly, and notifying the user as
appropriate.
--
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 abo
ch database created after that will
have the function.
As a corollary to that, you'll need to create the function in all
existing databases, since changes to the template database only apply to
new databases.
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
The 7.4
data directory isn't compatible with 8.1, so you'll need to perform the
dump and subsequent restore.
You'll probably also want to go through the 7.4 pg_hba.conf and
postgresql.conf files and port over any changes you need that are 8.1
compatible.
--
Chander Ganesan
O
timal plans...
I'm assuming that in the statement above you meant that you removed the
cluster and restored the entire cluster. If you just did the DB, it's
possible that other things might not be so well offespecially since
you don't know the root cause of the problem.
--
gards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Chander Ganesan [mailto:[EMAIL PROTECTED]
Sent: Mon 2/11/2008 11:47 AM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] 8.3.0 upgrade, confused by documentation
Tena Sakai wrote:
>
>
>
> I am going fr
ecial cases, etc. that the old version fails under -
while the new version will not.
Chander
Assuming I am wrong (ie., what it says does apply to me),
where in the steps (after 4 and before 8) do I make the
backup?
I'd appreciate someone to de-confuse me.
Regards,
Tena Sakai
[EMAIL PROTE
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,
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
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
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
s well. Is it? I'm assuming that (by your text above) that
the file already exists but no new output appears there - this may be
because the file is owned by the root user. You should probably change
the ownership of the file so that the postgresql user can write to it.
hope that helps.
may already
have that cost if you do PITR backups.
There is no way to have postgresql "switch" data directories to speed up
startup.
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
919-463-0999/866-229-3386
http://www.otg-nc.com
hat the WAL records are
written in 16MB segments. If the WAL containing my recovery target
hasn't been written yet, how can I determine when it has and is
available to me?
I'm running 8.2 on CentsOS 5, if it matters any.
--
Chander Ganesan
Open Technology Group, Inc.
One Copley P
then things will
be in sync so long as the remote system didn't crash, and if you are
using Protocol A then things should be in sync as long as the local
system didn't crash.
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
919-463-09
seem to significant to me,
but it all depends on the size of your tables, update/delete profile, etc.
--
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
---(end of broadcas
37 matches
Mail list logo
