Member Avatar for tanha

Hi.
I know this is MySQl forum, but maybe some one help me through the below issue:

I don't know which file I should download to install postgreSQL, could nayone please guide me which I should download ???

http://www.postgresql.org/ftp/source/v8.3.1/

I am using Windows OS.

  • 2 Contributors
  • 5 Replies
  • 106 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by tanha

Dani AI

Generated

Useful follow-ups to what and found: pick a supported PostgreSQL release for your OS and matching architecture (32-bit vs 64-bit). Very old builds (8.3.x) and Ubuntu 7.10 are both end-of-life; for stability and security use a modern PostgreSQL and a supported Ubuntu release. Official download and platform-specific install instructions are in the PostgreSQL docs and the Ubuntu page linked below.

After installation the common next steps that are often missed:

  • Set a password for the default superuser and create a role+database for your application.
  • Restrict remote access in pg_hba.conf and enable listening only where needed (listen_addresses) to avoid exposing the server unintentionally.
  • Verify the server is running and start/stop it with the OS service tools.

Quick examples (run as a DB superuser or via psql):

psql -U postgres
\password postgres
CREATE ROLE appuser WITH LOGIN PASSWORD 'strongpass';
CREATE DATABASE appdb OWNER appuser;

Example pg_hba.conf host line to allow a LAN subnet (use CIDR appropriate to your network):

# TYPE  DATABASE  USER  ADDRESS           METHOD
host    all       all   192.168.1.0/24    md5

For backups and migration use pg_dump / pg_dumpall:

pg_dump -U appuser -Fc appdb > appdb.dump
pg_dumpall -U postgres > all_databases.sql

Additional tips: match client tools (pgAdmin) to the server version, keep regular backups, test restores, and avoid running production on an unsupported OS. See the official docs for configuration details and platform-specific install instructions: PostgreSQL documentation and PostgreSQL on Ubuntu.

Recommended Answers

All 5 Replies

Member Avatar for tesuji

Hi tanha,

as far as I know there are only binaries for win32. You can download them there:

If you want to compile your own Postrgresql, you need to do this on Linux, for example Debian or openSuse.

btw, Postgresql covers all kind of user definded functions. The sort you are probably loooking for are there "query language functions".

krs,
tesu

Member Avatar for tanha

Thanks for the info and replying,
Actually I dont know more about binary files, and the link you posted, there are many files, and which ones I should download, and how can I use it? sorry for asking again.

Member Avatar for tesuji

1. unzip complete file in folder
2. carefully read readme.txt
(there are further links you should consider, especially faq. You should fully understand, how to deal with installing features BEFORE trying to install PostgreSQL)
3. run msi installer file

Postresql is a complete object-rational database system, what is also some kind of Oracle clone due to its own PL/SQL. MySql is not able to hold a candle to power PostgreSQL, entirely. Actually, it isn't that difficult to set up postgresql on win32. However, it is said that postgresql would run rather slower on win32 than an linux. I myself prefer linux.

krs,
tesu

Member Avatar for tanha

Thanks very much, yes I did what you mentioned, and finally I could do that...

Then about Linux, I am using Ubuntu "7.10" then which commands are used to install the postgreSQL completely?

Thanks in Advanced,

Member Avatar for tanha

I found the command of installing postgreSQL in Ubuntu 7.10 as follow:

sudo apt-get install postgresql postgresql-client postgresql-contrib

and if someone needs the GUI tools, then type the below command:

sudo apt-get install pgadmin3

Thanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.