On Wed, 2007-11-14 at 10:32 -0800, SHARMILA JOTHIRAJAH wrote:
> Hi
> I try to use pg_dump to dump my database.
> pg_dump smrs
> and it gives me an error
> pg_dump: failed sanity check, parent table OID 670739 of pg_rewrite
> entry OID 670741 not found
>
check out the --oids option in the manuals
Hello all,
I'd like to know if the autovacuum feature also deals with automatically
reindexing my indexes.
I know Pg8 know comes with a more eficient management of indexes, but I
also read in the manuals that it's still good practice to routine
reindex de most critical (in terms of speed) indexes
> | system("su postgres -c \"pg_dumpall --clean > some_file\"");
>
> I'd try "su - postgres ..."; this will use postgres' environment here.
>
That was a good one but still didn't work
> | this is run from within a Perl module called from within a Perl script.
> |
> | I've tried the same
Hello all,
I got surprised by this message:
-
The program "pg_dump" is needed by pg_dumpall but was not found in the
same directory as "/usr/bin/pg_dumpall".
Check your installation.
--
It's quite strange because I'm quite t
On Tue, 2007-10-16 at 15:51 -0700, Ben wrote:
> You could take a look at pg_statio_user_indexes and/or
> pg_stat_user_indexes, if you have stats enabled
>
> On Tue, 16 Oct 2007, Bryan Murphy wrote:
If your intention is to eliminate the unused indexes rows you should run
'vaccum' and/or 'vacu
On Fri, 2007-10-12 at 14:09 -0500, Erik Jones wrote:
> On Oct 12, 2007, at 1:59 PM, Richard Huxton wrote:
>
> > Joao Miguel Ferrei
> Are you restricted to keep that second server in that special run-
> level? If not, I'd consider using pg_standby with WAL archiving to
> keep your failover serv
Hello,
I have a 'strange' situation:
I need to make a replica copy of my database to a reduntant spare
computer.
The reduntant computer is not running postgres, but postgres is
installed. The redundant computer is running in a special run-level (I'm
talking Linux here) in which Pg is _not_ runni
Hello,
I have a 'strange' situation:
I need to make a replica copy of my database to a reduntant
spare
computer.
The reduntant computer is not running postgres, but postgres is
installed. The redundant computer is running in
Hello All,
my database contains a big table. on this table I create VIEWs.
The problem is this: the VIEWs are created dinamically by an external
program (depending on some configurations). Nevertheless I would like to
GRANT SELECT priviliges to my readOnlyUser, in a simple way...!!!
Summary: is
On Mon, 2006-05-08 at 18:07, Bruno Wolff III wrote:
> Please keep replies copied to the list so that others can learn from and
> contribute to the discussion. I don't remember where this was, but it looks
> like general is probably reasonable.
Sorry. I didn't notice. I'll keep that in mind.
> >
10 matches
Mail list logo
