Albert Shih wrote:
> Le 11/02/2010 à 17:00:33-0600, Kevin Grittner a écrit
> > Albert Shih wrote:
> >
> > > I would like to known what's best way to manage the WAL.
> >
> > You should design a policy which meets your particular needs. We
> > keep two PITR base backups and all the WAL files f
Le 11/02/2010 à 17:00:33-0600, Kevin Grittner a écrit
> Albert Shih wrote:
>
> > I would like to known what's best way to manage the WAL.
>
> You should design a policy which meets your particular needs. We
> keep two PITR base backups and all the WAL files from before the
> start of the fir
Albert Shih wrote:
> I would like to known what's best way to manage the WAL.
You should design a policy which meets your particular needs. We
keep two PITR base backups and all the WAL files from before the
start of the first (based on the information in the backup file)
through current. We
Le 11/02/2010 à 16:20:26-0600, Kevin Grittner a écrit
> Albert Shih wrote:
>
> > How can I clean up the pg_xlog directory ?
> >
> > I've 710 go of those file.
> >
> > I've archive_mode on but not in the pg_xlog directory
> > I've something like
> >
> > archive_mode = on # a
Hi all
I would like to known what's best way to manage the WAL.
Let's me explain :
at beginning I do something like
psql -c "select pg_start_backup('complete');"
rsync /pgsql backup_server:
psql -c "select pg_stop_backup();"
and I backu
On Thu, 2010-02-11 at 23:09 +0100, Albert Shih wrote:
> Hi all
>
> How can I clean up the pg_xlog directory ?
>
> I've 710 go of those file.
>
> I've archive_mode on but not in the pg_xlog directory
> I've something like
>
> archive_mode = on # allows archiving to be done
> ar
Albert Shih wrote:
> How can I clean up the pg_xlog directory ?
>
> I've 710 go of those file.
>
> I've archive_mode on but not in the pg_xlog directory
> I've something like
>
> archive_mode = on # allows archiving to be done
> archive_command = 'cp -i %p /databases/Archive
Hi all
How can I clean up the pg_xlog directory ?
I've 710 go of those file.
I've archive_mode on but not in the pg_xlog directory
I've something like
archive_mode = on # allows archiving to be done
archive_command = 'cp -i %p /databases/Archives/WAL/%f http://www.postgresql.o
Is there a document desribing (ar at least listing) new/obsolete
configuration parameters in postgresql.conf, when upgrading from version
to version?
Regards,
Igor Neyman
Hola Rafael.
You could generate a UUID. There is a contrib module in contrib/uuid-ossp
with several functions in order to generate an UUID with different
algorithms, as documentation says.
If you dont want to use these functions because you use an specific
format, perhaps they could serve you
"Meehan, Steven" writes:
> I had joined your site to post a PostgreSQL opening but had removed
> myself because of getting all of these emails.
Yes, that's called a mailing list. That's like a free support forum,
operated by mail.
http://en.wikipedia.org/wiki/Mailing_list
> Can you please re
Luis Dominguez wrote:
> I am now in the process of migrating a database from a driver
> ms sql server 7.0 to postgresql 8.4 vesion but I have a problem
> with the data type (timestamp) SQL Server 7.0 that refers to a
> single binary field that is updated randomly by row, and this
> field is para
Good
morning, I am now in the process of migrating a database from a driver
ms sql server 7.0 to postgresql 8.4 vesion but I have a problem with
the data type (timestamp) SQL Server 7.0 that refers to a single
binary field that is updated randomly by row, and this field is
paramount in my applic
ustedes para
ver si me pueden echar una mano con este bache que tengo ahorita ¡
Saludos
Luis Dominguez
_
__ Información de ESET NOD32 Antivirus, versión de la base de firmas
de virus 4857 (20100211) __
ESET NOD32 Antivirus ha comprobado este mensaje.
http
Buenos dias, estoy en estos momentos en un proceso
de migracion de una base de datos de un manejador ms sql server 7.0 a
postgresql vesion 8.4 pero tengo un problema con un tipo de dato el
(timestamp) que en sql server 7.0 se refiere a un campo binario unico
que se actualiza en forma aleator
Hi,
I am struck with a problm could anyone help me out here plz..
I have a problem while replicating my database in same machine via PgAdmin
on Windows, When I try to initiate a new Slony cluster in the PgAdmin
interface, the status-bar says "Slony-I creation scripts not available; only
joining p
Hi Josh.
I have followed your suggestion and restored bad tables into a file.
This has shortened the conversion process since I've only restored to
file bad chars tables, and only 8 showed this issue. So, instead of
having to fix full dump (about 45G) I only had to process 10MB (8
tables). This is
17 matches
Mail list logo
