From: | Dario Brignardello <dbrignar(at)gmail(dot)com> |
---|---|
To: | Ramon Orticio <rporticio(at)yahoo(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: 2 Questions |
Date: | 2005-12-23 04:51:48 |
Message-ID: | 45dd8dbe0512222051g49cbd8e0g3f8fa2eb2ba622e8@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi, Ramon,
> 1. how do you create or transfer to another location
> postgres database aside from the initial
> PGDATA=/var/lib/pgsql/data
You must perform an initdb -D /path/to/new/data/directory
and then:
a) set the PGDATA variable either in your shell
environment files (.bashrc, .bash_profile) or at the prompt with
'export PGDATA=/path/to/new/data/directory' or
b) start the postmaster with the -D flag (-D /path/to/....)
> 2. how can a jpeg or bmp file be stored in postgres.
>
Using large objects, a long time have passed since I did that, you
should check the docs (
http://www.postgresql.org/docs/8.1/static/largeobjects.html ) ...
however, are you sure you want to do it that way ?
Hope it helps, feliz navidad ;-)
Best regards
Dario
--
Atte: Dario Brignardello
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim GUNDUZ | 2005-12-23 07:49:01 | Re: 2 Questions |
Previous Message | Tom Lane | 2005-12-23 04:46:34 | Re: Postgres 8.1 choosing the larger index for an index scan |