1-9
> SET CLIENT_ENCODING='LATIN'; -- Where you substitute for the
correct number
> \copy
--
Tommy Gildseth
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Péter Kovács wrote:
Hi,
Which catalog view holds the version of the back-end?
SELECT setting FROM pg_settings WHERE name = 'server_version';
--
Tommy Gildseth
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.post
he users (with their passwords) and
the roles?
pg_dumpall -g
If need be, you can edit the resulting SQL to only move over the bits
you need.
--
Tommy Gildseth
DBA, Gruppe for databasedrift
Universitetet i Oslo, USIT
m: +47 45 86 38 50
t: +47 22 85 29 39
--
Sent via pgsql-admin mailing list (pgsql-
.
Once you've identified the culprit, you could use reindex or cluster to
reclaim the dead space.
Note that reindex and cluster require fairly extensive locks, so not so
good to use on a busy database during working hours.
--
Tommy Gildseth
--
Sent via pgsql-admin mailing list (pgsql-
rder to make it possible to
run multiple versions of postgreSQL on the same machine.
--
Tommy Gildseth
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
How about database specific config settings?
SELECT datname, datconfig FROM pg_database;
--
Tommy Gildseth
Julius Tuskenis wrote:
Yes, it is undefined (#timezone = unknown) just like in other servers.
Julius
Vishal Arora rašė:
Have you checked timezone parameter in postgresql.conf file
ctive/functions-admin.html
--
Tommy Gildseth
DBA, Gruppe for databasedrift
Universitetet i Oslo, USIT
m: +47 45 86 38 50
t: +47 22 85 29 39
---(end of broadcast)---
TIP 6: explain analyze is your friend
asily write custom plugins to cover your specific needs.
--
Tommy Gildseth
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
5678 is
PostgreSQL 8.2.4.
Should be fine, as long as you ensure that the pg_dump you use, is the
one from your 8.2.4 installation, and not the 8.1.4 version.
--
Tommy Gildseth
DBA, Gruppe for databasedrift
Universitetet i Oslo, USIT
m: +47 45 86 38 50
t: +47 22 85 29 39
