oking good.
Thanks.
jeff
On Fri, May 27, 2016 at 9:17 PM Jeff Baldwin wrote:
> Thanks Greg,
>
> Sounds like I've unknowingly stumbled onto a good path, the one you
> suggested.
>
> I actually installed v9.5 on the target server. I have it running on a
> different po
Thanks Greg,
Sounds like I've unknowingly stumbled onto a good path, the one you
suggested.
I actually installed v9.5 on the target server. I have it running on a
different port (5444) and using a different data directory than the v8.3
install.
I'm doing the dump, and forwarding it to the remo
t.
> Additional bonus: it's all standard Postgres tools (in contrast to e.g. a
> fancy trigger-based replication) and will also keep any statistics and
> analyzes.
>
>
>
> Best regards,
>
> -hannes
>
>
>
>
> Am 27. Mai 2016 23:23:04 MESZ, schrieb Jeff Bal
Thank you for your time Alan.
I'd like to confirm my understanding of your statement, and ask a question.
To move the DB, you are suggesting something like this:
pg_dump -h dbms11 -U postgres -C mls11 | psql -h localhost -d mls11 -U
postgres
I'm not familiar with removing/adding indexes (I'm no
PM Melvin Davidson
wrote:
>
>
> On Fri, May 27, 2016 at 5:09 PM, Jeff Baldwin
> wrote:
>
>> Melvin,
>>
>> Thank you for taking the time to reply to my question.
>>
>> Below are the details you have requested:
>>
>> SOURCE:
>> CentOS re
6 at 4:56 PM, Jeff Baldwin
> wrote:
>
>> Hello,
>>
>> I am working to migrate 2 DB's (not the entire postgres instance), from 1
>> host to another... and I need some guidance on the best approach/practice.
>>
>> I have migrated ~25 other DB's in th
Hello,
I am working to migrate 2 DB's (not the entire postgres instance), from 1
host to another... and I need some guidance on the best approach/practice.
I have migrated ~25 other DB's in this environment, and I was able to use
pg_dump/pgrestore for those, and it worked fine. These final 2 are
