CODEWITHSUNDEEP
windowspostgresql
xAminex
xAminex

Reputation: 473

Using Postgresql as application server ( windows server )

I'm building an application to fill a database that I made with postgres. It's possible to install postgresql on an existing windows Windows server ? If yes can you give me a lead of how to do it ? because I found on the internet that it's possible only with .NET Framework and that confuses me. Just for information , this database should be updated from many users that have the access to the server.

Thanks in advance.

Upvotes: 0

Views: 541

Answers (2)

Craig Ringer
Craig Ringer

Reputation: 324265

On the server simply use the installer.

On client systems, it depends on how your app accesses the database. You might need to install the ODBC driver psqlODBC. You might need to bundle nPgSQL or PgJDBC with your app. Etc. It depends on the tools and languages you're using.

Note that PostgreSQL isn't a graphical user interface to a database. It has no form builder etc. It's just a database engine and you need an application to provide a user interface.

Upvotes: 1

SWiggels
SWiggels

Reputation: 2296

You can simply install PGAdmin on the mentioned server. It includes a copy of postgre-server. You can add users easily with the pgadmin interface or use the cmd if you prefer to add users using psql.

Btw: you don't need .NET stuff with this solution.

Answers drawn together:

  • For administrative clients: just install pgadmin there as well.
  • For software-clients (read/write) you don't need to install anything to connect to the server (your application should handle that) so no third-party.

If you want to move your current database to a new server you can either:

  1. make a db-dump and load it using pgadmin (works with different pg versions)
  2. Do as listed here (console)

Upvotes: 1

Related Questions