Tom,
I only see this in pg_clog:
[EMAIL PROTECTED] data]# ls pg_clog/
No, I had not been running Vacuum on a regular interval. :( I just
added "vacuumdb --all" to my daily cron, though...
On Feb 22, 2004, at 6:04 PM, Tom Lane wrote:
"Bethany A.Benzur" <[EMAIL PROTECTED]> writes:
Argg... I g
"Bethany A.Benzur" <[EMAIL PROTECTED]> writes:
> Argg... I guess I won't be rebuilding template1 from template0 seeing
> as I have no template0!! :(
> template1=> UPDATE pg_database SET datallowconn = TRUE
> template1-> WHERE datname = 'template0';
> UPDATE 0
Hm. I'm beginning to think you've g
Argg... I guess I won't be rebuilding template1 from template0 seeing
as I have no template0!! :(
template1=> UPDATE pg_database SET datallowconn = TRUE
template1-> WHERE datname = 'template0';
UPDATE 0
I'm running out of ideas here... how will I get my databases out and
back in without pg_dump?
Hmmm ... I'm wondering about version mismatches between your psql and
your backend. Does "psql -V" agree with the backend version?
[EMAIL PROTECTED] ]$ psql -V
psql (PostgreSQL) 7.2.4
However, I am not totally convinced that that's where your problem is.
Do you see failures when you are connected
"Bethany A.Benzur" <[EMAIL PROTECTED]> writes:
> I have been running postgres for quite some time with this problem:
> whenever a user logs in or issues almost any command in the "psql"
> client, they get this error:
> -bash-2.05b$ psql
> ERROR: Relation "pg_user" does not exist
Hmmm ... I'm w
Hello,
I have been running postgres for quite some time with this problem:
whenever a user logs in or issues almost any command in the "psql"
client, they get this error:
-bash-2.05b$ psql
ERROR: Relation "pg_user" does not exist
postgres=> \l
ERROR: Relation "pg_user" does not exist
postgres=