Hi All,
I am concerned with the impact autovacuum of table(s) would have on
regular DB activity.
With our current DB's the majority of tables have either a low number of
updates or a large number of inserts (which I believe should not be a
problem), however, a small number of tables have an extre
Sorry I accidentally pressed 'Send'...
Forwarded Message
From: Enzo Daddario <[EMAIL PROTECTED]>
To: pgsql-admin@postgresql.org
Subject: autovacuum
Date: Mon, 23 Jan 2006 13:07:21 +0800
Hi All,
I am concerned with the impact autovacuum of table(s) would have on
regular DB activi
>
>
> This seems insecure.
>
> How do I create a postgreSQL user account such that attempts to connect
> to it require authentication?
>
http://www.postgresql.org/docs/8.1/interactive/client-authentication.html
>
> -Dan
>
> ---(end of broadcast)--
On Sun, 22 Jan 2006, Dan Bikle wrote:
> I'm allowed to connect to the db10 database without authentication!:
>
> bash-2.05b$ psql db10 scott
> Welcome to psql 8.1.1, the PostgreSQL interactive terminal.
>
> Type: ＼copyright for distribution terms
>＼h for help with SQL commands
>＼
People,
I just installed postgreSQL 8.1.1 on my free-bsd box:
Creation of a database is easy:
bash-2.05b$ id
uid=70(pgsql) gid=70(pgsql) groups=70(pgsql)
bash-2.05b$ createdb -O pgsql db10
CREATE DATABASE
bash-2.05b$
I took a peek at help:
bash-2.05b$ psql --help
This is psql 8.1.1, the Postg
"Ciprian Hodorogea" <[EMAIL PROTECTED]> writes:
> 1. I noticed that binary dumps created with Postgres 8.0.3 can not be
> imported with Postgres 8.1.x, so this is not a good backup idea.
If you mean a filesystem dump, no.
> 2. All dumps generated with pg_dump seem to contain internal function
Hi All,
1. I noticed that binary dumps created with
Postgres 8.0.3 can not be imported with Postgres 8.1.x, so this is not a good
backup idea.
2. All dumps generated with pg_dump seem to contain
internal functions also, which then raise problems when trying to import. Can
these
