OK, a couple of issues:
1) creation date and time on pg_xlog file is irrelevant, since AFAIK, they are
recycled.
2) Why do you start_backup, archive WAL files somewhere else and then stop
backup?
If i understand correctly, you are explaining the process of data creation,
backup and restoratio
pedro noticioso <[EMAIL PROTECTED]> writes:
> I created a log of my complete procedure so far, and
> the error message at the end, pleasse help me find
> exactly what is wrong, thanks
It looks to me like you've gotten confused about which installation is
the original and which is the attempted rec
pedro noticioso wrote:
> regresamos wal files a pg_xlog - COPY BACKED UP WAL
> FILES BACK TO pg_xlog DIRECTORY
This step is wrong. You don't have to manually put the pg_xlog files in
the pg_xlog directory -- you have to let the recovery_command copy them
back from the archive area. Note that re
I created a log of my complete procedure so far, and
the error message at the end, pleasse help me find
exactly what is wrong, thanks
1)
Postgres recien instalado - POSTGRES NEW INSTALL
2)
Creando db de Pruebas - - CREATE TESTING DATABASE
# createdb Test
3) iniciamos procedimiento de respaldo
for the base backup I tried with the procedure
outlined in
http://www.postgresql.org/docs/8.1/static/backup-online.html#BACKUP-BASE-BACKUP
and using
tar zcvf /usr/local/pgsql/data/
and to restore deleted WAL files at pg_xlog because
they are older than the WAL files in /backup/wals dir
mentione
It comes under Server Startup:
http://www.postgresql.org/docs/8.2/static/server-start.html
Ray Stell wrote:
Many thx. It that in the doc?
On Thu, Feb 15, 2007 at 06:21:05PM +, Andy Shellam (Mailing Lists) wrote:
The cluster's "name" is only the file-system's directory path.
You
Many thx. It that in the doc?
On Thu, Feb 15, 2007 at 06:21:05PM +, Andy Shellam (Mailing Lists) wrote:
> The cluster's "name" is only the file-system's directory path.
>
> You can easily rename this directory, as long as you pass the relevant
> directory name to pg_ctl's -D parameter (
Ray Stell wrote:
> What I was trying to get at is, is mv of the dir ok or
> is there something else that needs to be considered? Thx.
Renaming the directory is OK. Just make sure your init script or
whatever finds it.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
-
The cluster's "name" is only the file-system's directory path.
You can easily rename this directory, as long as you pass the relevant
directory name to pg_ctl's -D parameter (which tells PostgreSQL which
database "cluster" to use.)
It goes without saying, don't move the directory while Postgr
On Thu, Feb 15, 2007 at 06:36:23PM +0100, Peter Eisentraut wrote:
> Ray Stell wrote:
> > Is there a method to rename a cluster?
>
> Clusters don't have names in the first place.
So, from 16.2 "Creating a Database Cluster"
"...you must initialize a database storage area on disk.
We call this a da
gayathri jayapal wrote:
Hai,
I started working on postgresql, I want to know how to write the "
connect by" clause of oracle. My problem is i have a table with id,
parent id. In same table i will insert the record with parent id as
previous row id. I want fetch the records in the hierarchy. how
Ray Stell wrote:
> Is there a method to rename a cluster?
Clusters don't have names in the first place.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map setti
Is there a method to rename a cluster?
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
Tom Lane wrote:
"Cassiano, Marco" <[EMAIL PROTECTED]> writes:
If I understand well, PgAdmin fails in composing the correct pg_dump command.
The switch combination -t collezioni -n anamat doesn't work. The
manual says that the -n switch is ignored when -t is used
The right (at least, working)
"Cassiano, Marco" <[EMAIL PROTECTED]> writes:
> If I understand well, PgAdmin fails in composing the correct pg_dump command.
> The switch combination -t collezioni -n anamat doesn't work. The
> manual says that the -n switch is ignored when -t is used
> The right (at least, working) syntax seems t
Adam Radłowski wrote:
> Dear friends !
> The suggestion:
> Sometimes You problems may be found with other people, who don't know
> Your language. So - after discussion and making conclusions try explain
> the problem very short in english.
> I'm not a admin of this mailing list, so treat my lette
Jaime Casanova escribió:
> Alvaro, un vacuum como superusuario podria haber arreglado algo? o
> hubiera tenido que borrar la tupla que pareciera mas vieja? o ninguna
> de ambas podria haber funcionado? estoy asumiendo que el problema es
> el que mencione arriba, no se me ocurre que mas pudo ser...
Hello everybody,
I have a problem when I try to backup a table from inside PgAdmin.
If I select a table and choose to backup it, I get the following result :
C:\Programmi\pgAdmin III\1.6\pg_dump.exe -i -h pgsvil.manord.com -p 5432 -U
user -F c -v -f "C:\collezioni.backup" -t collezioni -n anam
18 matches
Mail list logo