Run PostgreSQL without installing

This issue appears very often in all kinds of forums. "So, this recipe is worth sharing" – we thought. And that's usually how it happens

Objective: to run the PostgreSQL server on a desktop computer or a server running Windows without installing it, possibly with portable media.



There are situations when you really need it. For example, your program does not require installation but uses the PostgreSQL server. Or you do not have permission to install (update) of the server on this machine.

So what you need to do:

    the
  1. To start the necessary binary files for Windows server. Can copy the PostgreSQL folder (minus the folder data) from an existing server installation, or just download the files from the website PostgreSQL Windows. Make sure that you have selected .zip archive.
    2. the
  2. Then copy the following batch file in the root of the new folder PostgreSQL.
    3. the
  3. Upon first use, uncomment the line in the call to initdb.
    4. the
  4. Run the batch file.


Below is the script that starts the PostgreSQL server and clicking the enter key (Enter), stop the service. The script we use in the Autonomous set of development and testing under PostgreSQL 9.0-beta. We are launching a process on a non-standard port (5439 so that you know that this is the 9.0 server). To initialize the database the first time, you will need to run the command initdb. You need to initialize the database only once. Then you can transfer the folder to a USB drive if you want. Variable %CD% returns the path to the folder where the batch file is located.

@ECHO ON
REM Set environment variables to run PostgreSQL
@SET PATH="%CD%\bin";%PATH%
@SET PGDATA=%CD%\data
@SET PGDATABASE=postgres
@SET PGUSER=postgres
@SET PGPORT=5439
@SET PGLOCALEDIR=%CD%\share\locale
REM %CD%\bin\initdb -U postgres -A trust
%CD%\bin\pg_ctl -D %CD%/data -l logfile start
ECHO "Press Enter to stop the server"
pause
%CD%\bin\pg_ctl -D %CD%/data stop
Article based on information from habrahabr.ru

Комментарии

Отправить комментарий

Популярные сообщения из этого блога

Fresh hay from the cow, or 3000 icons submitted!

Изображение
After the release of the 2000 icons FatCow more than a year . In her fourth year of drawing. the Page called for 560,096 (288,511+235,221+36,364) visitors . To reach 3500 icons, the works will last until February 2013. If you add the size of 64x64, then to mid-2015. While invested $76778 and 2000 hours. Then put 3000 icons , a week before the release on the official website, because the owners of the cows (Bluehost) busy buying crocodile ( HostGator ). / > To understand which icons are the most unique in the world, had to sort 7422 icons. The result did not disappoint... and it turned out that the percentage of unique icons 85,53% cows , 55,90% James and 68,59% from Yusuke. 17.15% — so % unique icons more Fatcow than Fugue . Our designer worked 3.5 hours a day, 5 days per week, for 4 consecutive years. As at the manufactory. Using specially crafted for our set generator Corvo from Berezin Artyom, woven two carpet, put through photoshop and get lep
Далее...

Knowledge base. Part 2. Freebase: make requests to the Google Knowledge Graph

Изображение
More than a year ago, Google announced that from now on in their search is the mysterious Knowledge Network (an official translation of the Knowledge Graph). Perhaps not everyone knows that a significant part of the data Network available for anyone to use and available via well described APIs. This part is the knowledge base Freebase, supported by Google and enthusiasts. In this article, we first a little nuts, and then try to do a few simple queries in MQL. This article is the second of the knowledge Base. Stay tuned. the the Part 1 — Introduction the Part 2 — Freebase: we make requests to the Google Knowledge Graph the Part 3 — Dbpedia — a kernel of the world of Linked Data the Part 4 — Wikidata — semantic Wikipedia Google Knowledge Graph from the point of view of an ordinary user One of the visible manifestations of the Google Knowledge Graph is the information panel that briefly describes the object that you are looking for. They often arise from the se
Далее...

Group edit the resources (documents) using MIGXDB

Изображение
I wonder the opportunities offered by component MIGX from Bruno17 for MODX Revolution . While he looks clumsy and there are mistakes, but the critical problem. All that is written in this article important for MIGX version 2.5.8-pl (the latter at the moment). / > Many people use MIGX for creating photo galleries , but its functionality is not limited. A real designer to manage data of any database tables. You can even display a list of child resources (documents of MODX) in any container. This will be discussed in this article. Something I learned from documentation MIGDB but, as I understand, it is already rather outdated and much of what is described there simply doesn't work. I will tell you how to make a table with nested resources: 1. Open "Components" -> "MIGX". Go to the tab "MIGX". Click "Add item". 2. On the "Settings" tab to enter a name (Name) of the configuration, for example "ch
Далее...