Hi,
I use PostgreSQL 7.2 on Linux Red hat 7.2.
The server crash, and after this crash we have some performance problem.
And i stop the postmaster and start the standalone server.
I make
REINDEX database test force
and this work well.
But when i make :
Reindex table tbl_fw_focal_system
For the moment the problem isn't resolv but i'm working on.
I want to know. What is the files under the directory pg_xlog.
Is this directory contains the logs for the systems transactions ?
I ask this questions because when i restore the filesystem.
When i firts restart the database. The postm
Sorry for CC,
psql -h 192.168.133.15 -l
List of available databases :
Name | Owner
-+--
template0 | alf
template1 | alf
otherdb | alf
Directory base :
[alf@cpa-linux3 base]$ ll
total 24
drwx--2 alf alf 4096
I'm new to postgresql . I use the version 7.2 on RedHat 7.2
I have made a mistake. I drop a database but not the good database.
And I have a file systems backup.
But what I didn't know until now, is that the postmaster should be stop in
order to make the backup.
So when the backup is made, the p
