Hello,
I have a table where an oid field is used for saving images. I'm thinking
about getting a little snapshot of all images without downloading the full
images. I only want to download some entire images. I'm thinking in something
like this:
create table images (
id serial primary key,
tit
Hello,
I wonder if postgres autocreates an index on foreign or primary key fields.
For example:
create table t1 (
f1 integer,
f2 varchar,
primary key (f1));
create table t2 (
f1 integer,
f2 integer,
primary key (f1),
foreign key (f2) references t1(f1)
);
In this sample, "t1" has a
The user DB that connects to the remote DB has insert and delete
permissions
(he is the owner of the DB).
The question is ... how can I block or forbide the remote DB duplication
?. I think that a remote person that knows the user DB and his password,
can co
Hello,
First of all sorry about my bad command in english.
I have an Internet server with postgres 7.4.7, planned to give remote db
services.
I have several offices, with client programs that connect to the internet
DB server vía a SSH tunnel.
The user DB that connects to the remote DB has inser
>[EMAIL PROTECTED] (Thomas F. O'Connell) writes:
>> I transfer this file to another server, where the database db does not
>> exist. I try the following:
>
>> pg_restore -C -d db pg_dump20040621.pgsql
>> pg_restore: [archiver (db)] connection to database "db" failed: FATAL:
>> database "db" does n
Thanks you very much Tom,
Here is the solution to the problem:
First: We have to restore (only) the structure (schema) of the database
pg_restore -Ft -v -s db.tar -d database_name -U postgres -S postgres --disable-triggers
Second: Restore the datas
pg_restore -Ft -v -a db.tar -d database_name -U
>> I do this, from Saturn:
>> pg_dump -Ft -b -U dbuser -h saturn dbsample > db.tar
>> Then, I create the user and database in Saturno, and perform this:
>> pg_restore -Ft -v db.tar -d dbsample -U dbuser
>> But, pg_restore stops, showing this message:
>
>> pg_restore: fixing large object cross-refer
Hello,
I have two servers running postgres 7.3 (Server Jupiter), and 7.4.3 (Sever
Saturn), in my office. I have a master database in Jupiter, that contains
a DB with images, OIDs (lo type).
I'm trying to backup the database from Jupiter and restore it in Saturn.
I do this, from Saturn:
pg_dump
Hello,
I have two servers running postgres 7.3 (Server Jupiter), and 7.4.3 (Sever
Saturn), in my office. I have a master database in Jupiter, that contains
a DB with images, OIDs (lo type).
I'm trying to backup the database from Jupiter and restore it in Saturn.
I do this, from Saturno:
pg_dump
