Hi.

As the portable pgAdmin 3 currently works only up tp pgsql v9.6, when I download v9.6 and run it:

1. paf - gives an error saying that the format is incorrect. Tried downloading many times but same result.
2. zip - installed and ran it but just a momentary flash of the windows cmd window and exits.

I'm running Win10 64-bit

Alternatively, is there a portable version of pgAdmin that will work with pgs 10.x?

Appreciate your help.

Hi,

I suggest to support a distro for Linux (ex. Ubuntu)

what's the password set to by default?

When I change port number in file postgresql.conf Postgresql want start. Can You check it?

Read that the issue session isn't only for issues but for ideas as well. I've been using this portable version of PG for my personal project. Would be nice if it could be started without any windows showing completely hidden. For my application this would be nice because i'm developing a content manager that works directly from an usb drive for my use only and i don't want the prompt window showing alongside with my main app, anyway, it is just an idea. Congratulations for this awesome portable version of PG.

Great work on making this portable!

Would you be able to add instructions on how to run it? I've looked through the help documents and read me and can't figure out how to launch the process or specify a port.

Ping!

It's Postgresql 10 update time!

I would like install PostGIS on this portable version. Can it work?

Just came across this. If I have a database already on a server can I restore it or copy it into the Portable version? THis is an awesome project. I normally use Embedded FirebirdSQL for certain apps,but this may change that for me.

When we forcefully close using taskkill /F /IM PostgreSQLPortable.exe /t it don't start next time and ask for cleanup

is there any command which can be run from windows terminal to close this gracefully ?

How it do the cleanup can't we manually clear files ?

Hi
any chance for v 11 portable?
thanks

Hello,

How do I make PostgreSQLPortable listen on more than just 127.0.0.1? I tried updating the pg_hba.conf to the following:

host all all 0.0.0.0/0 @authmethodhost@

Uncommented in postgresql.conf:

hba_file = 'ConfigDir/pg_hba.conf' # host-based authentication file
listen_addresses = '*'

Restarted, and it still doesn't work. My firewall is set to allow the port to go through as well.

Thanks!

hi,

To get the last updated binay is correct to download from https://www.enterprisedb.com/download-postgresql-binaries?
Then extract files from folder "pgsql" in the binary "postgresql-16.2-1-windows-x64-binaries.zip" to ...\PostgreSQLPortable\App\PgSQL
And for last run PostgreSQLPortable.exe.

Thanks

Hello,

I have some problems to start Postresql portable. I'm not sure where it might come from, but I would like to know if it is a 32-bit or 64-bit version ?

On the official Postgresql website, both versions are available.

Regards,
Nicolas.

Is it possible to support postgresql 9.6?

In v9.6+ you can get the following error if the Visual C++ redistributables aren't installed.

Can you post the code of "PostgreSQLPortable.exe" file ? or the commands you used to run the server ?

Hi, I am trying to run PostgreSQLPortable.exe - nothing happens.
For cmd file it says

\postgresql-portable-9.6\PostgreSQLPortable\App\PgSQL\bin\psql.exe"' is not recognized as an internal or external command,
operable program or batch file.
\postgresql-portable-9.6\PostgreSQLPortable\App\PgSQL\bin\pg_ctl"' is not recognized as an internal or external command,
operable program or batch file.

what would be the easieast way of migrating full data to newer portable version?
exmaple 9.3.5 to 9.5 ?
basically wahts the easieast , that preserve all data, roles, constraints etc..

I added Portable Postgres to my project. Let me know if you need anything/reports bugs etc! Thanks!

Java Android Magisk Burp Objection Root Emulator Easy (JAMBOREE)
https://github.com/freeload101/Java-Android-Magisk-Burp-Objection-Root-Emulator-Easy

Hi,
first of all let me thank you very, very, very much for this portable edition:
thank you again!

Now the issue: I'm using the latest release PostgreSQLPortable_10.4.1_online.paf.exe,
along with a binary distribution of python for win-32 bit from anaconda:
https://anaconda.org/anaconda/python/3.4.4/download/win-32/python-3.4.4-5.tar.bz2

but when I try to create a function in python, the db backend drops.

(user) =# create extension plpython3u;
CREATE EXTENSION
(user )=# CREATE FUNCTION pymax (a integer, b integer)
(user) -# RETURNS integer
(user) -# AS $$
(user) $# if a > b:
(user) $# return a
(user) $# return b
(user) $# $$ LANGUAGE plpython3u;
il server ha chiuso la connessione inaspettatamente
Questo probabilmente indica che il server ha terminato in modo anormale
prima o durante l'elaborazione della richiesta.
Connessione al server persa. Tentativo di reset: Fallito.

May you please be so kind to point me to which binary python distro should I use (with no admin right required for installing, of course)?

With kindly regards,
/gp

How can I change default postgres password.
I tried from console "\password postgres" but not working.

I would like to block user connection without password.
How to do that?

Thanks advance.

I downloaded PostgreSQLPortable_10.4.1.zip and unzipped it on my portable disk in a subdir named pgsql.
The psql opens and prompts okay.
How can I create a database for a project on a Windows machine in a directory, say, on disk D: somedir/somesubdir/someproject?
Shall I add the pgsql dir to the Windows Path on that PC?
Must I place the pgsql directory on the root of my portable disk as I had to for xampp?
(edited Jan 26, 2019)
I also saw your comment at SourceForge on the repository of the pgAdmin portable repository saying that you "use it extensively to control my PostgreSQL Portable instance - and it works great".
Can you please explain me how?

Thank you.

P.S: Almost all programmer/support tools I use are portable versions on a portable disk.
Even my Git install, for example, is a portable, and I managed to configure it to open the git-bash anywhere from the command line (on Windows I have to put it on the Path). And also my xampp, although I had to unzip it on the root of the disk to make it work.

The application appears to be fairly up to date, but no mention is made of Windows 10 support.

Is that an oversight?