On Jan 25, 2008 1:55 PM, NUWAN LIYANAGE <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a 450gb production database, and was trying to create a development
> database using a bkp.
> I was following the instructions on postgres documentation, and came across
> the paragraph that says...
> " If you
Incrementing pg_database.datfrozenxid sounded like an excellent idea.
Before I made any changes I dumped the contents of pg_database to see what
it contained. Here is that dump:
backend> select * from pg_database;
WARNING: database "vsa" must be vacuumed within 997398 transactions
HINT: To avoi
Steven Rosenstein <[EMAIL PROTECTED]> writes:
> I used plain old VACUUM. Do you think VACUUM FULL might be faster or more
> effective?
No. I think you probably want to do a dump and reload, but first you
have to get past the anti-wraparound check.
One possibility I hadn't thought of before is t
I am unable to run pg_dump because even though I can successfully start the
postmaster, every time I try to do something I receive the warning that the
postmaster will not allow any activity because we crossed the minimum
transaction threshold. pg_dump dies almost immediately:
Starting dump to
/v
I used plain old VACUUM. Do you think VACUUM FULL might be faster or more
effective?
Here is the Resource Usage section from the config file (sorry for the mild
spam). Everything looks like it is still in a default state. I'm sure
upping the shared_buffers and the max_fsm_pages would make a dif
On Jan 25, 2008 2:05 PM, Adam Talaat <[EMAIL PROTECTED]> wrote:
>
>
> Hello,
>
> Are the database files created by 32-bit PostgreSQL identical to the files
> created by 64-bit PostgreSQL?
No.
---(end of broadcast)---
TIP 3: Have you checked our exte
Hello,
Are the database files created by 32-bit PostgreSQL identical to the files
created by 64-bit PostgreSQL? The database files would reside on a SAN or
DAS device external to the servers. If the server running a 64-bit
installation of PostgreSQL were to fail, would we be able to bring a serve
Hello,
I have a 450gb production database, and was trying to create a
development database using a bkp.
I was following the instructions on postgres documentation, and came across
the paragraph that says...
" If you are using tablespaces that do not reside underneath this (data)
On Fri, Jan 25, 2008 at 02:10:06PM -0500, Tom Lane wrote:
> > I used lsof to monitor which files the backend was actually working on. It
> > took two of the four days for it to vacuum a single table with 43
> > one-gigabyte extents. I have one table with over 300 extents. I'm looking
> > at a v
Steven Rosenstein <[EMAIL PROTECTED]> writes:
> I did as instructed, and fired up the standalone backend. I then started
> VACUUM. About four days later, the standalone backend terminated with the
> message:
> WARNING: terminating connection because of crash of another server process
> DETAIL:
I recently inherited a server with a PostgreSQL 8.1.8 database. The reason
I inherited it was because "it wasn't working anymore".
A quick look in the logfiles showed the following:
LOG: transaction ID wrap limit is 2147484146, limited by database "vsa"
WARNING: database "vsa" must be vacuume
On Jan 25, 2008 10:02 AM, PostgreSQL Admin
<[EMAIL PROTECTED]> wrote:
> We are using this bad piece of the software that does not close
> connections to the postgres server. Is there some setting for closing
> dead connections? And not TCP/IP keep alive does not work.
If the TCP keepalive can't d
We are using this bad piece of the software that does not close
connections to the postgres server. Is there some setting for closing
dead connections? And not TCP/IP keep alive does not work.
---(end of broadcast)---
TIP 6: explain analyze is yo
Dear all
I am a newbie postgresql admin. I use FME GIS Tool to translate mapinfo
file to postgis. My problem is the translation tools use encoding of the
system as postgis client encoding. (System encoding is "WINDOWS-874-2000").
However postgis client is recognise only encoding name "WIN874". Th
On Fri, 2008-01-25 at 11:34 +1100, Phillip Smith wrote:
> > We have a center in Europe who has just started to use PostgreSQL and was
> > asking me if there are any Symantec product or other products that backup
> > this type of database.
>
> It doesn't appear to.
The design of the PITR system a
15 matches
Mail list logo
