On Mar 24, 2006, at 5:19 PM, Peter Eisentraut wrote:
Thomas F. O'Connell wrote:
So long as I know that nothing will access the recovery database with
write activity, is there a way to toggle the continuity so that I
could allow recovery to complete on a nightly basis, pg_dump the
recovered dat
Hi,
I just renamed some of my tables, but I now have sequences with older names.
I followed info from
http://www.postgresql.org/docs/current/static/sql-altersequence.html :
"Some variants of ALTER TABLE can be used withsequences as well; for
example, to rename a sequence use ALTERT
Two questions in this regard please?
1) Is tuple theory not the root of this problem
2) Vacuum does much the same as a traditional database reorg, and online reorgs are a reality now
1) If I understand tuple theory correctly, copies of rows are created through normal Postgres processing, that exp
Hi
Is is safe to assume that the unix ls command will return
WAL files in the same sequence as postgres creates them.
e.g will ls return files in the
order that postgres created them
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Thu, 23 Mar 2006, Bradley Kieser wrote:
>> last_backup: timestamp
>> backup_unit: integer - Represents day, week, quarter, annual, etc. The
>> text is stored in backup_code (e.g. 'days', 'months')
>> backup_period: integer - Represents the skip factor.
Thomas F. O'Connell wrote:
> So long as I know that nothing will access the recovery database with
> write activity, is there a way to toggle the continuity so that I
> could allow recovery to complete on a nightly basis, pg_dump the
> recovered database (a read-only action), and then resume recove
On Thu, 23 Mar 2006, Bradley Kieser wrote:
> All,
>
> I know that this isn't strictly an admin question but please forgive me
> for asking.
> I am writing a (admin) job which does a select off a PG database based
> on three columns:
>
> last_backup: timestamp
> backup_unit: integer - Represents d
Title: JDBC conncetion fails, please, advise
Hi,
Please can you assist.
I am trying to connect to PostgreSQL via JDBC.
Database version is 8.0.1 and java software version 1.4.2.
I have configured the pg_hba.conf file as follows
host all all ip_address/32 trust
ip_address is th
Hi,
I met a headache problem. I'm a novice of PostgreSQL.
I create a database with name "Users" and the encoding is UTF8.
But when I connected the database and input \d command to list relations, I met a strange exception.
Users=> show server_version; server_version 8.1
All,
I know that this isn't strictly an admin question but please forgive me
for asking.
I am writing a (admin) job which does a select off a PG database based
on three columns:
last_backup: timestamp
backup_unit: integer - Represents day, week, quarter, annual, etc. The
text is stored in ba
Good day!
I have found library "libpq.lib" for visual c++ (package PostgreSQL
8), but for borland builder give me error for using this library.
Where I can find "libpq.lib" for borland builder (win2000)?
thanks.
---(end of broadcast)---
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
| I have the same issue too. I can only use the space bar to go down the
| results, page up and down keys do not work and neither does the end key.
Thank you Bruce! I lost any hope that I'd get any answer in this
newsgroup, so I posted the same qu
Okay, the picture is becoming clearer (to me) in terms of a
continuous on-line backup scenario with postgres, and now I'd like to
get more understanding of how flexible it is.
Currently, I nightly pg_dump an entire cluster. I ship it to a remote
server where I restore it. This has dual util
On Fri, Mar 24, 2006 at 12:12:54PM -0500, Pallav Kalva wrote:
> Jim C. Nasby wrote:
> >On Fri, Mar 24, 2006 at 10:39:41AM -0500, Pallav Kalva wrote:
> >
> >> What do you think about this option ? If I just do scp from the
> >>/archives folder, I will be ok and wont copy any partial files at any
Jim C. Nasby wrote:
On Fri, Mar 24, 2006 at 10:39:41AM -0500, Pallav Kalva wrote:
What do you think about this option ? If I just do scp from the
/archives folder, I will be ok and wont copy any partial files at any
time right ?
archive_command = 'cp %p /archives-temp/%f && mv /archives-temp
On Fri, Mar 24, 2006 at 10:39:41AM -0500, Pallav Kalva wrote:
> What do you think about this option ? If I just do scp from the
> /archives folder, I will be ok and wont copy any partial files at any
> time right ?
> archive_command = 'cp %p /archives-temp/%f && mv /archives-temp/%f
> /archive
On Fri, Mar 24, 2006 at 10:02:01AM -0500, Tom Lane wrote:
> Actually, I wonder whether VACUUM FULL shouldn't be thrown away and
> replaced by something else entirely. That algorithm only really works
> nicely when just a small percentage of the rows need to be moved to
> re-compact the table --- i
Jim C. Nasby wrote:
On Thu, Mar 23, 2006 at 12:28:41PM -0800, Steve Crawford wrote:
...I have a
cron job from the production database that runs every 5-10min to check
if there are any new archive logs and copy new archive logs to the
remote stand by failover machine.
The problem with this
=?ISO-8859-2?Q?R=F3zsahegyi_L=E1szl=F3?= <[EMAIL PROTECTED]> writes:
> The dump of my database is about 2 GB if we are lucky.
> If not, we have one of error messages:
> - pg_dump: ERROR: invalid memory alloc request size 2623204397
> - pg_dump: ERROR: could not access status of transaction 24
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Am Freitag, 24. März 2006 05:48 schrieb Tom Lane:
>> Well, the VACUUM FULL algorithm is incapable of shrinking indexes ---
>> the only way is REINDEX, or something else that reconstructs indexes
>> from scratch, such as CLUSTER. One of the things we n
Hi,
I have created a static library application which uses our
postgres function calls.And i have a dll application which uses the static
library application ...
but this dll i am unable to build as it is asking for
libpqdll.lib.
Can't i use the static version of it i.e.,libpq.lib?
I have
On Thu, Mar 23, 2006 at 12:28:41PM -0800, Steve Crawford wrote:
> >...I have a
> >cron job from the production database that runs every 5-10min to check
> >if there are any new archive logs and copy new archive logs to the
> >remote stand by failover machine.
> >
> >The problem with this scenario
Robin Iddon wrote:
>> But I think there might be some underlying problem and if so, i'd
>> like to know about it and fix it.
>>
>>
> It seems to me that the JVM is having problems writing to the socket
> that connects to the postgres server with the "Network is unreachable"
> error being the caus
Am Freitag, 24. März 2006 05:48 schrieb Tom Lane:
> Well, the VACUUM FULL algorithm is incapable of shrinking indexes ---
> the only way is REINDEX, or something else that reconstructs indexes
> from scratch, such as CLUSTER. One of the things we need to look into
> is putting more smarts into VAC
Hi!
We have a Sun Fire V480 server 4GB of memory with Solaris 10 operation system
and PostgreSQL 8.1.3 (from Sun).
The dump of my database is about 2 GB if we are lucky.
If not, we have one of error messages:
- pg_dump: ERROR: invalid memory alloc request size 2623204397
- pg_dump: ERROR:
25 matches
Mail list logo
