Getting Started in Postgresql

Congratulations! You will be very happy with your choices. The only change I would make is 's/Open/Net/g' but that's just me.

Your main concerns are not PostgreSQL or OpenBSD specific. They are

1. Unix-like operating system versus MS Windows. This is a big difference, but the changes are ALL positive. Any book that teaches the basics of *nix system administration will help. There are some good *BSD specific books out there, although I learned Linux (RedHat) and then migrated to NetBSD.

2. Real relational database management system versus "Ronco All In One Database, Report Generator, Application Development System. That's right, it slices, it dices, it Juliennes fries..." Any good book on any good relational database management system will do. The theory is far more important than the syntax or database specific functionality. I learned MS SQL Server and had absolutely no difficulty whatsoever with PostgreSQL.

You are very lucky to be allowed to escape the tyrrany of software that makes you work the way it wants, to software that works the way you want. I went from spending entire 8 hour days trying to figure out how to work around things like the fact that Access did not work as advertised (including cut and paste from the Knowledge Base) or discovering undocumented limitations like the number of nested subqueries, to spending my time developing my application.

Anyway, specifically I recommend Bruce's book for PostgreSQL stuff, and have heard good things about Joe Celko's books on SQL generally. The docs are actually quite good, once you come to understand where things are hidden. I recommend buying them in book form or printing them so you can actually READ them, as opposed to on-line, even though they will be out of date within minutes of being committed to paper. You can always refer to the online copies, but for trying to absorb the gist of the whole thing, paper is better.

Have fun!

Ian Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
iharding@tpchd.org
(253) 798-3549

"If any man can convince me and bring home to me that I do not think or act aright, gladly will I change; for I search after truth, by which man never yet was harmed. But he is harmed who abideth on still in his deception and ignorance"

-- Marcus Aurelius

Daniel Anderson <dan3487@yahoo.com> 03/12/03 03:26AM >>>

Hi,

At work I was assigned the task of migrating a
very large (and very unmanageable) MS Access
database to a solution that would be massively
scalable and support a number of simultaneous
users and features.[1]I've already figured out that I can save MS Access files as text and COPY them to the postgres database.

After lengthy study I concluded that Postgresql
running on OpenBSD would be ideal[2]The discussion of exactly why I chose OpenBSD and Postgresql is beyond the scope of this e-mail, but I would be more then happy to discuss/debate/explain why to anybody who e-mails me. (dan3487@yahoo.com). So now I
am designing and implementing programs to allow a
number of clients to connect to the database over
the network.[3]Suffice it to say each and every OpenBSD box needs to completely automate connection to the database (including the use of barcode scanners) at a number of different points across the floor, all connected via 802.11b. So my job is to design a system and code it to make it work.

I was wondering if anybody could recommend good
books, resources, references, or otherwise
general starting points to help steer me in the
right direction? I've been through the docs and
at this point am just trying to remember
everything (it's quite overwhelming!) But any
suggestions to make the life of a postgres noob
easier would be welcomed. =)

Thanks,

Dan Anderson
Lab Rat and Helper Monkey
Great Lakes Industries, Inc.

[1]: I've already figured out that I can save MS Access files as text and COPY them to the postgres database.
Access files as text and COPY them to the
postgres database.
[2]: The discussion of exactly why I chose OpenBSD and Postgresql is beyond the scope of this e-mail, but I would be more then happy to discuss/debate/explain why to anybody who e-mails me. (dan3487@yahoo.com)
OpenBSD and Postgresql is beyond the scope of
this e-mail, but I would be more then happy to
discuss/debate/explain why to anybody who e-mails
me. (dan3487@yahoo.com)
[3]: Suffice it to say each and every OpenBSD box needs to completely automate connection to the database (including the use of barcode scanners) at a number of different points across the floor, all connected via 802.11b. So my job is to design a system and code it to make it work.
needs to completely automate connection to the
database (including the use of barcode scanners)
at a number of different points across the floor,
all connected via 802.11b. So my job is to
design a system and code it to make it work.

__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

There is plenty to learn about PostgreSQL, but you are
more likely to have actual trouble in dealing with the
strange ways of MS Access. These oddities are not
visible while you are doing everything in Access, but
start to appear when you go down the linked tables
road.

Your procedure is simple enough conceptually:
1. Migrate your data to PostgreSQL
2. Set up the ODBC driver with appropriate DSN(s)
3. Link to the new tables

As usual, the devil is in the details.

Migration: there are various ways you could do this.
I have had good success using the migration wizard
that comes as a plugin with PGAdminII:
http://pgadmin.postgresql.org
I recommend that you look at PGAdminII, both for
migration and as a good tool for interacting with
PostgreSQL from Windows.

ODBC: Check out http://odbc.postgresql.org . You can
get the ODBC driver there, and plenty of information
too (if you install PGAdminII, I believe you will get
the ODBC driver as part of the package).

General PostgreSQL: You appear to have looked at the
documentation already. Make sure to check out
http://techdocs.postgresql.org , which has plenty of
useful practical information. Also, I suggest that
you subscribe to the pgsql-odbc mailing list, if you
have not done so already. You can find answers to
most problems by searching the archives of that list.

Access: the almost-canonical "Access Developers
Handbook" has a good coverage of the issues involved
in linking via ODBC to remote databases. That book is
an excellent resource for Access in all ways, and I
suggest that you get it if you don't have it already.

If you have specific difficulties/questions just post
to the -general or -odbc lists (depending on the
subject matter), but please be sure to check the
mailing list archives first (go to
http://www.postgresql.org).
HTH

--- Daniel Anderson <dan3487@yahoo.com> wrote:

Hi,

At work I was assigned the task of migrating a
very large (and very unmanageable) MS Access
database to a solution that would be massively
scalable and support a number of simultaneous
users and features.[1]

After lengthy study I concluded that Postgresql
running on OpenBSD would be ideal[2]. So now I
am designing and implementing programs to allow a
number of clients to connect to the database over
the network.[3]

I was wondering if anybody could recommend good
books, resources, references, or otherwise
general starting points to help steer me in the
right direction? I've been through the docs and
at this point am just trying to remember
everything (it's quite overwhelming!) But any
suggestions to make the life of a postgres noob
easier would be welcomed. =)

Thanks,

Dan Anderson
Lab Rat and Helper Monkey
Great Lakes Industries, Inc.

[1] I've already figured out that I can save MS
Access files as text and COPY them to the
postgres database.
[2] The discussion of exactly why I chose
OpenBSD and Postgresql is beyond the scope of
this e-mail, but I would be more then happy to
discuss/debate/explain why to anybody who e-mails
me. (dan3487@yahoo.com)
[3] Suffice it to say each and every OpenBSD box
needs to completely automate connection to the
database (including the use of barcode scanners)
at a number of different points across the floor,
all connected via 802.11b. So my job is to
design a system and code it to make it work.

__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com

---------------------------(end of
broadcast)---------------------------
TIP 2: you can get off all lists at once with the
unregister command
(send "unregister YourEmailAddressHere" to

majordomo@postgresql.org)

__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com

On Wed, 12 Mar 2003, Daniel Anderson wrote:

I was wondering if anybody could recommend good
books, resources, references, or otherwise
general starting points to help steer me in the
right direction? I've been through the docs and
at this point am just trying to remember
everything (it's quite overwhelming!) But any
suggestions to make the life of a postgres noob
easier would be welcomed. =)

Read the administrator's guide again and again. When you first
start running Postgresql there's so much good information in there that it
can't really all stick the first few times, it has to build up by layers.

for database migration, you can use the pgadmin's database migration plug-in

you can find pgadmin at
http://pgadmin.postgresql.org/

regards
Serkan Bektas

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Daniel Anderson
Sent: Wednesday, March 12, 2003 1:26 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Getting Started in Postgresql

Hi,

At work I was assigned the task of migrating a
very large (and very unmanageable) MS Access
database to a solution that would be massively
scalable and support a number of simultaneous
users and features.[1]I've already figured out that I can save MS Access files as text and COPY them to the postgres database.

After lengthy study I concluded that Postgresql
running on OpenBSD would be ideal[2]The discussion of exactly why I chose OpenBSD and Postgresql is beyond the scope of this e-mail, but I would be more then happy to discuss/debate/explain why to anybody who e-mails me. (dan3487@yahoo.com). So now I
am designing and implementing programs to allow a
number of clients to connect to the database over
the network.[3]Suffice it to say each and every OpenBSD box needs to completely automate connection to the database (including the use of barcode scanners) at a number of different points across the floor, all connected via 802.11b. So my job is to design a system and code it to make it work.

I was wondering if anybody could recommend good
books, resources, references, or otherwise
general starting points to help steer me in the
right direction? I've been through the docs and
at this point am just trying to remember
everything (it's quite overwhelming!) But any
suggestions to make the life of a postgres noob
easier would be welcomed. =)

Thanks,

Dan Anderson
Lab Rat and Helper Monkey
Great Lakes Industries, Inc.

[1]: I've already figured out that I can save MS Access files as text and COPY them to the postgres database.
Access files as text and COPY them to the
postgres database.
[2]: The discussion of exactly why I chose OpenBSD and Postgresql is beyond the scope of this e-mail, but I would be more then happy to discuss/debate/explain why to anybody who e-mails me. (dan3487@yahoo.com)
OpenBSD and Postgresql is beyond the scope of
this e-mail, but I would be more then happy to
discuss/debate/explain why to anybody who e-mails
me. (dan3487@yahoo.com)
[3]: Suffice it to say each and every OpenBSD box needs to completely automate connection to the database (including the use of barcode scanners) at a number of different points across the floor, all connected via 802.11b. So my job is to design a system and code it to make it work.
needs to completely automate connection to the
database (including the use of barcode scanners)
at a number of different points across the floor,
all connected via 802.11b. So my job is to
design a system and code it to make it work.

__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)