HI,
Again.
I'm installing 8.2.3 on another machine and want to use Navicat to transfer my data to the new machine from 7.4.8.
I've changed pg_hba.conf to 'host all all 0.0.0.0/0 trust',
postgresql.conf to 'listen = '*',
disabled firewalls.
I can ping the machine.
The username and password are identical.
Reinstalled 8.2.3.
7.4.8 is still fully functional.
psping shows no active listening on my chosen port: 5823.
I _can_ connect from 7.4.8 to the server where the database is a separate installation.
repository_server is enabled, but still seeking created database. Tried 'repository_server' as well. No joy.
Short of the firewall, there doesn't seem to be access restrictions. Even permitted the port under the firewall. No joy there, either.
I could try to backup my files, but defeats remote access to the database for admin.
It doesn't appear that the embedded database is actually using those config files.
Is there a limitation to the embedded database where I cannot remotely access the database for updates or backups?
Thanks,
--Joe.