From: | "Walter Dnes" <waltdnes(at)waltdnes(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | New user questions |
Date: | 2005-11-25 03:25:03 |
Message-ID: | 20051125032503.GA14143@waltdnes.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm running PostgreSQL 8.0.3, the latest stable ebuild, on Gentoo linux.
1) Am I inviting any problems in linux by moving the directory
/var/lib/postgresql to /home/postgresql, and then symlinking
/home/postgresql back to /var/lib/postgresql? The reason for this is
to avoid having databases, indexes, etc, physically ending up on my
/dev/sda1 partition, which I want to reserve for the OS only.
2) Although I have an AMD64 cpu. I chickened out and went for a 32-bit
install. If/when I do migrate to 64-bit, can I keep my databases, or
will I have to export/import them?
3) Are there any free sample datasets and tutorials for users who are
familiar with SQL and Oracle PL/SQL? I have no DBA experience, but I do
write quite a few read-only Oracle SQL queries and PL/SQL programs at
work, even though I'm not a CS. An Oracle-to-PostgreSQL comparison
would be nice to see.
--
Walter Dnes <waltdnes(at)waltdnes(dot)org> In linux /sbin/init is Job #1
My musings on technology and security at http://tech_sec.blog.ca
From | Date | Subject | |
---|---|---|---|
Next Message | surabhi.ahuja | 2005-11-25 04:12:38 | regarding the apostrophe character |
Previous Message | Jerry Sievers | 2005-11-25 02:39:21 | Re: pg_connect troubles on localhost |