Out the box installation will get you a system up and running, from there you have a choice of tools you can use such as Navicat to connect to the database. I am assuming you have networked machines. You then can create a new database, tables and populate them with data. The Oracle SGA is truthfully an Oracle feature as it is compromised of a group of Oracle specific structures. A lot of the functionality you get from a SGA in Oracle is closely tied to the operating system with postgres.
Configuration files you can find in the data directory of your postgres installation, postgres.conf would be the most mappable conf file to a init.ora Running the unix command find postgres.conf will be helpful. ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of kartik Sent: Wednesday, June 25, 2008 5:01 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] Query Hello there, I am installing postgresql on debian os. So can anyone please tell me how to configure it .. and I have few windows clients that needs to be connected to the database server.. can anyone please tell me something about how to configure the server and the client ... thanks _______________________________________________________ The information in this email or in any file attached hereto is intended only for the personal and confiden- tial use of the individual or entity to which it is addressed and may contain information that is propri- etary and confidential. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communica- tion is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product. Email trans- mission cannot be guaranteed to be secure or error- free. P6070214