cardo.org/check_postgres/check_postgres.pl.html#backends
--
Jeff Frost, Owner
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 916-647-6411 FAX: 916-405-4032
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
h
restore. Then you simply pass it
through psql like so:
psql -f /tmp/postgres.backup.`hostname` postgres
Hint: the above will require that the CREATE DATABASE and \connect
commands for the database you want to restore are still in the file.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Fro
Jeff Frost wrote:
> Chris Henderson wrote:
>
>> I backup all my databases by using pg_dumpall - pg_dumpall >
>> /tmp/postgres.backup.`hostname`. It should backup four DBs: analyze,
>> postgres, template0 and template1
>> I guess this backs up the schemas as
f and reload, you can just do it in the
session you're in:
set work_mem=512000;
create index blah blah blah;
Doesn't he want to change maintenance_work_mem instead of work_mem for index
creation?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://w
;
default_statistics_target
---
100
(1 row)
Time: 0.318 ms
jefftest=# \q
discord:~ $ pg_dumpall --globals|grep default_statistics_target
discord:~ $ pg_dump jefftest | grep default_statistics_target
discord:~ $
--
Jeff Frost, Owner
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 916-647-6411 FAX: 916-405-4032
passwords.
So I chose md5 but it will not work, seems like a basic thing. So I am
forced to use "trust".
How on earth does failure of md5 to work force you to use trust?
How about crypt or password (password is pretty darn simple to set up).
--
Jeff Frost, Owner
Frost Consulti
On Thu, 29 Jan 2009, Tom Lane wrote:
Jeff Frost writes:
Tom one thing I noticed recently is that pg_dumpall --globals doesn't
seem to pick up when you alter the GUCs at the database level and
neither does pg_dump. How should you dump to grab that per-database
stuff?
Regular pg_dumpall
Jeff Frost wrote:
> On Thu, 29 Jan 2009, Tom Lane wrote:
>
>> Jeff Frost writes:
>>> Tom one thing I noticed recently is that pg_dumpall --globals doesn't
>>> seem to pick up when you alter the GUCs at the database level and
>>> neither does pg_dump. H
hen is the last time you ran ANALYZE? That's what the -z option does. If
you're only vacuuming once daily, you should definitely analyze with the -z
flag as well.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650
eek to complete. Any help would
be greatly appreciated.
Benjamin,
When is the last time you ran ANALYZE? That's what the -z option does. If
you're only vacuuming once daily, you should definitely analyze with the -z
flag as well.
--
Jeff Frost, Owner <[EMAIL PROT
http://www.postgresql.org/about/donate
<http://www.postgresql.org/about/donate>
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/ab
11 matches
Mail list logo
