Feedback-ID: i76984098:Fastmail
Message-ID: <25e61545-624f-4de3-99c6-47b42d136d2c@aklaver.com>
Date: Tue, 28 Apr 2026 09:27:07 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: can recs be transferred between DBs ?
To: dfgpostgres <dfgpostgres3@gmail.com>, pgsql-general@postgresql.org
References: <CAAcmDX9t2Od6DmPs3zUq=P2jDFhm-wiVsdF5=+yp=OtsYt1vxQ@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAAcmDX9t2Od6DmPs3zUq=P2jDFhm-wiVsdF5=+yp=OtsYt1vxQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/25e61545-624f-4de3-99c6-47b42d136d2c%40aklaver.com>
Precedence: bulk


On 4/28/26 8:56 AM, dfgpostgres wrote:
> psql (15.3, server 15.15) on linux
> 
> dvdb=# \d arch_restore
>                    Table "misc.arch_restore"
>   Column |       Type        | Collation | Nullable | Default
> --------+-------------------+-----------+----------+---------
>   pk     | integer           |           | not null |
>   proj   | character varying |           |          |
>   data   | character varying |           |          |
> Indexes:
>      "arch_restore_pkey" PRIMARY KEY, btree (pk)
> 
> dvdb=# select * from arch_restore order by pk;
>   pk | proj  |    data
> ----+-------+------------
>    1 | alpha | the_data_1
>    2 | alpha | the_data_2
>    3 | alpha | the_data_3
>    4 | beta  | the_data_4
>    5 | beta  | the_data_5
>    6 | beta  | the_data_6
>    7 | gamma | the_data_7
>    8 | gamma | the_data_8
>    9 | gamma | the_data_9
> (9 rows)
> 
> I decided that it's time to archive the 'beta' project.  So I create a 
> new DB in the PG instance and put them all there leaving...

How did you transfer the data to the new database and could you not use 
the same process to transfer the beta data back?

> 
> Thanks in Advance