Hope there is bad sector. Did u checked restoring the backup DB to ur local
server?
On Wed, Sep 23, 2009 at 9:50 AM, nalini nal...@nic.in wrote:
Backup is with pg_dump -Ft command ie tar backup
- Original Message -
From: S Arvind arvindw...@gmail.com
Date: Tuesday, September 22,
Yes there are bad sectors . I tried to restore backup on a local server but the
dump fails with the error somenumber.dat missing
- Original Message -
From: S Arvind arvindw...@gmail.com
Date: Tuesday, September 22, 2009 11:25 pm
Subject: Re: [ADMIN] Recover postgres database
To: nalini
I have observed the following situation a few times now (weeks or months
apart), most recently with 8.3.7. Some postgres child process crashes.
The postmaster notices and sends SIGQUIT to all other children. Once
all other children have exited, it would enter recovery. But for some
reason, some
Hello guys,
I'm configuring a new server, and I would to authenticate the users via
LDAP. We already have systems doing this, like Intranet (Joomla! Framework)
and Imap Mail.
So, for tests, I added the following line in the pg_hba.conf (according the
Postgres Documentation):
hostall
Peter Eisentraut pete...@gmx.net writes:
I have observed the following situation a few times now (weeks or months
apart), most recently with 8.3.7. Some postgres child process crashes.
The postmaster notices and sends SIGQUIT to all other children. Once
all other children have exited, it
Isabella Ghiurea isabella.ghiu...@nrc-cnrc.gc.ca writes:
SELECT nspname || '.' || relname AS
relation,pg_size_pretty(pg_total_relation_size(nspname || '.' ||
relname)) AS s
ize
FROM pg_class C
LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
ORDER BY pg_relation_size(nspname ||
Hi All,
Tom, please see bellow are the results for the modified query with ORDER
BY
select pg_size_pretty(pg_database_size('db1'));
pg_size_pretty
12 GB
SELECT 'the table size without table space restrictions';
SELECT nspname || '.' || relname AS
Isabella Ghiurea isabella.ghiu...@nrc-cnrc.gc.ca writes:
SELECT nspname || '.' || relname AS
relation,pg_size_pretty(pg_total_relation_size(nspname || '.' || relname))
AS s
ize
FROM pg_class C
LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
ORDER BY pg_total_relation_size(nspname
Hi All,
looking in more details on OS partitions sizwe and each table space
corresponding to OS partitions will add up to close to 6,5GB for db size
same result as SQL table size.
The issue may be with pg_size_pretty() results, I don't have details
knowledge of this function.
select
Isabella Ghiurea isabella.ghiu...@nrc-cnrc.gc.ca writes:
The issue may be with pg_size_pretty() results, I don't have details
knowledge of this function.
I doubt it, that's a pretty simple function ... but if you don't trust
it, just remove the pg_size_pretty call and look directly at the
Hi.
I accidentally deleted pg_toast record from pg_class table that belongs to
regular table (reltoastrelid).
Now [select * from table_name] not work:
ERROR: could not open relation with OID [oid_of_pg_toast_table]
Is it possible to restore corruption?
--
---
Regards,
M.Nasedkin
11 matches
Mail list logo