I have done the migration from access to postgres under a linux environment (I also changed all the code to php from asp)
here is a couple of things to note when doing the same:
-> When installing PostGreSQL: (Refer mainly to the documentation online postgres.org)
- First compile, make and get use to the idea of a seperate user for accessing the database (one called postgres, and another for apache (also called apache))
- Make sure there is a share/db inside your postmaster (sql server) even if it's not setup
- Connect to your server in the unix console (not using tcp) and if it works, try get ot to startup on boot (you will need to use the long address for accessing the terminal client named 'psql')
- Once you are certain your database is running when you're computer boots, now setup the TCP connection
- Here's why: If you were like me and you straight away try to connect to your database over the network and get "connection refused" for half a day, it's because the service is not running properly, solution?
- Trouble shooting, start the service in terminal with no logging (to stop the process at any time use ctrl+c), open another terminal and use 'psql localhost' (you might need the full location to access psql) which means your server works, then try getting loggin working and it starting on boot
- Petty damn sure that you don't have access on tcp? then mybe you don't, you need to add your host to the pb_something.conf file and allow tcp connections both in the postmaster.conf file and in your startup command (it looks something like
postmaster -N "data/location" -o '-i"
Refer to google.com for help on that
-There are programs which can copy your access database into postgres, but only in windows I think, I'm going to write a script tomorrow.. but it's in php so it probably wont help you, you can email me at firstname.lastname@example.org
to get these scripts
Once you get it going use the new postsql admin III for administrating it, it's wacky! but it;s so much more structured, and you'll eventually learn the proper way in which a database works (you're playing with the big boys now)