Thread: Cannot launch pgAdmin4
Dear Support,
I have installed PostgreSQL 9.6 on my computer which contains pgAdmin4 as well. When I try to launch pgAdmin4 I get the following message:
"Failed to connect to the pgAdmin application server. Click here to try again."
I didn't find any log or something which could give me more details about the connection problem.
Windows 10 is installed on my box and I don't have any firewall.
Do you have any idea how I can fix the issue.
Thank you!
Best regards,
Akos
On Sat, Oct 1, 2016 at 10:49 AM, Laczkóczki Ákos <laczkoczki.akos@gmail.com> wrote: > Dear Support, > > I have installed PostgreSQL 9.6 on my computer which contains pgAdmin4 as > well. When I try to launch pgAdmin4 I get the following message: > > "Failed to connect to the pgAdmin application server. Click here to try > again." > > I didn't find any log or something which could give me more details about > the connection problem. > > Windows 10 is installed on my box and I don't have any firewall. > > Do you have any idea how I can fix the issue. Have you installed any of the previous test releases of pgAdmin 4? You should find a log file under your %AppData% directory. On my test VM, the full path is: C:\Users\dpage\AppData\Roaming\pgAdmin\pgadmin.log -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
I have the following in the log file: (it is unusable to figure out what happens)
2016-10-03 19:43:28,607: INFO pgadmin: ########################################################
2016-10-03 19:43:28,607: INFO pgadmin: Starting pgAdmin 4 v1.0...
2016-10-03 19:43:28,607: INFO pgadmin: ########################################################
2016-10-03 19:46:55,230: INFO pgadmin: ########################################################
2016-10-03 19:46:55,230: INFO pgadmin: Starting pgAdmin 4 v1.0...
2016-10-03 19:46:55,230: INFO pgadmin: ########################################################
2016-10-03 19:58:46,273: INFO pgadmin: ########################################################
2016-10-03 19:58:46,273: INFO pgadmin: Starting pgAdmin 4 v1.0...
2016-10-03 19:58:46,273: INFO pgadmin: ########################################################
2016-10-03 20:06:49,503: INFO pgadmin: ########################################################
2016-10-03 20:06:49,503: INFO pgadmin: Starting pgAdmin 4 v1.0...
2016-10-03 20:06:49,503: INFO pgadmin: ########################################################
2016-10-03 20:35:58,332: INFO pgadmin: ########################################################
2016-10-03 20:35:58,332: INFO pgadmin: Starting pgAdmin 4 v1.0...
2016-10-03 20:35:58,332: INFO pgadmin: ########################################################
2016-10-03 20:48:17,717: INFO pgadmin: ########################################################
2016-10-03 20:48:17,717: INFO pgadmin: Starting pgAdmin 4 v1.0...
2016-10-03 20:48:17,717: INFO pgadmin: ########################################################
I have attached a shot about the pgAdmin right after launching it.
I have not installed any other version of PostgreSQL nor previous test release of pgAdmin 4 on my box.
On 3 October 2016 at 11:06, Dave Page <dpage@pgadmin.org> wrote:
On Sat, Oct 1, 2016 at 10:49 AM, Laczkóczki Ákos
<laczkoczki.akos@gmail.com> wrote:
> Dear Support,
>
> I have installed PostgreSQL 9.6 on my computer which contains pgAdmin4 as
> well. When I try to launch pgAdmin4 I get the following message:
>
> "Failed to connect to the pgAdmin application server. Click here to try
> again."
>
> I didn't find any log or something which could give me more details about
> the connection problem.
>
> Windows 10 is installed on my box and I don't have any firewall.
>
> Do you have any idea how I can fix the issue.
Have you installed any of the previous test releases of pgAdmin 4?
You should find a log file under your %AppData% directory. On my test
VM, the full path is:
C:\Users\dpage\AppData\Roaming\pgAdmin\pgadmin.log
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Attachment
On Mon, Oct 3, 2016 at 7:53 PM, Laczkóczki Ákos <laczkoczki.akos@gmail.com> wrote: > I have the following in the log file: (it is unusable to figure out what > happens) > > 2016-10-03 19:43:28,607: INFO pgadmin: > ######################################################## > 2016-10-03 19:43:28,607: INFO pgadmin: Starting pgAdmin 4 v1.0... > 2016-10-03 19:43:28,607: INFO pgadmin: > ######################################################## > 2016-10-03 19:46:55,230: INFO pgadmin: > ######################################################## > 2016-10-03 19:46:55,230: INFO pgadmin: Starting pgAdmin 4 v1.0... > 2016-10-03 19:46:55,230: INFO pgadmin: > ######################################################## > 2016-10-03 19:58:46,273: INFO pgadmin: > ######################################################## > 2016-10-03 19:58:46,273: INFO pgadmin: Starting pgAdmin 4 v1.0... > 2016-10-03 19:58:46,273: INFO pgadmin: > ######################################################## > 2016-10-03 20:06:49,503: INFO pgadmin: > ######################################################## > 2016-10-03 20:06:49,503: INFO pgadmin: Starting pgAdmin 4 v1.0... > 2016-10-03 20:06:49,503: INFO pgadmin: > ######################################################## > 2016-10-03 20:35:58,332: INFO pgadmin: > ######################################################## > 2016-10-03 20:35:58,332: INFO pgadmin: Starting pgAdmin 4 v1.0... > 2016-10-03 20:35:58,332: INFO pgadmin: > ######################################################## > 2016-10-03 20:48:17,717: INFO pgadmin: > ######################################################## > 2016-10-03 20:48:17,717: INFO pgadmin: Starting pgAdmin 4 v1.0... > 2016-10-03 20:48:17,717: INFO pgadmin: > ######################################################## > > I have attached a shot about the pgAdmin right after launching it. > > I have not installed any other version of PostgreSQL nor previous test > release of pgAdmin 4 on my box. Wow, that really is unhelpful. If you browse into the web/ directory in the installation directory, can you please add the following 2 lines to config_local.py, then re-run pgAdmin and check/send the logfile again? DEBUG = True FILE_LOG_LEVEL = 10 Thanks. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
I have added the two lines to config_local.py but the result is not saying any interesting to me in the log:
2016-10-07 09:35:20,704: INFO pgadmin: ########################################################
2016-10-07 09:35:20,704: INFO pgadmin: Starting pgAdmin 4 v1.0...
2016-10-07 09:35:20,704: INFO pgadmin: ########################################################
2016-10-07 09:35:20,704: DEBUG pgadmin: Python syspath: ['C:\\development\\tools\\postgresql\\9.6\\pgAdmin 4\\web', 'C:\\development\\tools\\postgresql\\9.6\\pgAdmin 4\\bin\\python27.zip', 'C:/development/tools/postgresql/9.6/pgAdmin 4/venv\\DLLs', 'C:/development/tools/postgresql/9.6/pgAdmin 4/venv\\lib', 'C:/development/tools/postgresql/9.6/pgAdmin 4/venv\\lib\\plat-win', 'C:/development/tools/postgresql/9.6/pgAdmin 4/venv\\lib\\lib-tk', 'C:\\development\\tools\\postgresql\\9.6\\pgAdmin 4\\bin', 'C:/development/tools/postgresql/9.6/pgAdmin 4/venv/Lib/site-packages', 'C:/development/tools/postgresql/9.6/pgAdmin 4/venv/DLLs', 'C:/development/tools/postgresql/9.6/pgAdmin 4/venv/Lib', 'C:\\development\\tools\\postgresql\\9.6\\pgAdmin 4\\venv\\DLLs', 'C:\\development\\tools\\postgresql\\9.6\\pgAdmin 4\\venv\\Lib\\lib-tk', 'C:\\development\\tools\\postgresql\\9.6\\pgAdmin 4\\venv\\Lib']
2016-10-07 09:35:20,704: DEBUG pgadmin: Available translations: [Locale('fr')]
On 4 October 2016 at 16:11, Dave Page <dpage@pgadmin.org> wrote:
Wow, that really is unhelpful. If you browse into the web/ directoryOn Mon, Oct 3, 2016 at 7:53 PM, Laczkóczki Ákos
<laczkoczki.akos@gmail.com> wrote:
> I have the following in the log file: (it is unusable to figure out what
> happens)
>
> 2016-10-03 19:43:28,607: INFO pgadmin:
> ########################################################
> 2016-10-03 19:43:28,607: INFO pgadmin: Starting pgAdmin 4 v1.0...
> 2016-10-03 19:43:28,607: INFO pgadmin:
> ########################################################
> 2016-10-03 19:46:55,230: INFO pgadmin:
> ########################################################
> 2016-10-03 19:46:55,230: INFO pgadmin: Starting pgAdmin 4 v1.0...
> 2016-10-03 19:46:55,230: INFO pgadmin:
> ########################################################
> 2016-10-03 19:58:46,273: INFO pgadmin:
> ########################################################
> 2016-10-03 19:58:46,273: INFO pgadmin: Starting pgAdmin 4 v1.0...
> 2016-10-03 19:58:46,273: INFO pgadmin:
> ########################################################
> 2016-10-03 20:06:49,503: INFO pgadmin:
> ########################################################
> 2016-10-03 20:06:49,503: INFO pgadmin: Starting pgAdmin 4 v1.0...
> 2016-10-03 20:06:49,503: INFO pgadmin:
> ########################################################
> 2016-10-03 20:35:58,332: INFO pgadmin:
> ########################################################
> 2016-10-03 20:35:58,332: INFO pgadmin: Starting pgAdmin 4 v1.0...
> 2016-10-03 20:35:58,332: INFO pgadmin:
> ########################################################
> 2016-10-03 20:48:17,717: INFO pgadmin:
> ########################################################
> 2016-10-03 20:48:17,717: INFO pgadmin: Starting pgAdmin 4 v1.0...
> 2016-10-03 20:48:17,717: INFO pgadmin:
> ########################################################
>
> I have attached a shot about the pgAdmin right after launching it.
>
> I have not installed any other version of PostgreSQL nor previous test
> release of pgAdmin 4 on my box.
in the installation directory, can you please add the following 2
lines to config_local.py, then re-run pgAdmin and check/send the
logfile again?
DEBUG = True
FILE_LOG_LEVEL = 10
Thanks.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
No, I agree :-(. Can you please try the standalone pgAdmin package from https://www.postgresql.org/ftp/pgadmin3/pgadmin4/v1.0/ and see if you get different results? Thanks. On Fri, Oct 7, 2016 at 8:38 AM, Laczkóczki Ákos <laczkoczki.akos@gmail.com> wrote: > I have added the two lines to config_local.py but the result is not saying > any interesting to me in the log: > > 2016-10-07 09:35:20,704: INFO pgadmin: > ######################################################## > 2016-10-07 09:35:20,704: INFO pgadmin: Starting pgAdmin 4 v1.0... > 2016-10-07 09:35:20,704: INFO pgadmin: > ######################################################## > 2016-10-07 09:35:20,704: DEBUG pgadmin: Python syspath: > ['C:\\development\\tools\\postgresql\\9.6\\pgAdmin 4\\web', > 'C:\\development\\tools\\postgresql\\9.6\\pgAdmin 4\\bin\\python27.zip', > 'C:/development/tools/postgresql/9.6/pgAdmin 4/venv\\DLLs', > 'C:/development/tools/postgresql/9.6/pgAdmin 4/venv\\lib', > 'C:/development/tools/postgresql/9.6/pgAdmin 4/venv\\lib\\plat-win', > 'C:/development/tools/postgresql/9.6/pgAdmin 4/venv\\lib\\lib-tk', > 'C:\\development\\tools\\postgresql\\9.6\\pgAdmin 4\\bin', > 'C:/development/tools/postgresql/9.6/pgAdmin 4/venv/Lib/site-packages', > 'C:/development/tools/postgresql/9.6/pgAdmin 4/venv/DLLs', > 'C:/development/tools/postgresql/9.6/pgAdmin 4/venv/Lib', > 'C:\\development\\tools\\postgresql\\9.6\\pgAdmin 4\\venv\\DLLs', > 'C:\\development\\tools\\postgresql\\9.6\\pgAdmin 4\\venv\\Lib\\lib-tk', > 'C:\\development\\tools\\postgresql\\9.6\\pgAdmin 4\\venv\\Lib'] > 2016-10-07 09:35:20,704: DEBUG pgadmin: Available translations: > [Locale('fr')] > > On 4 October 2016 at 16:11, Dave Page <dpage@pgadmin.org> wrote: >> >> On Mon, Oct 3, 2016 at 7:53 PM, Laczkóczki Ákos >> <laczkoczki.akos@gmail.com> wrote: >> > I have the following in the log file: (it is unusable to figure out what >> > happens) >> > >> > 2016-10-03 19:43:28,607: INFO pgadmin: >> > ######################################################## >> > 2016-10-03 19:43:28,607: INFO pgadmin: Starting pgAdmin 4 v1.0... >> > 2016-10-03 19:43:28,607: INFO pgadmin: >> > ######################################################## >> > 2016-10-03 19:46:55,230: INFO pgadmin: >> > ######################################################## >> > 2016-10-03 19:46:55,230: INFO pgadmin: Starting pgAdmin 4 v1.0... >> > 2016-10-03 19:46:55,230: INFO pgadmin: >> > ######################################################## >> > 2016-10-03 19:58:46,273: INFO pgadmin: >> > ######################################################## >> > 2016-10-03 19:58:46,273: INFO pgadmin: Starting pgAdmin 4 v1.0... >> > 2016-10-03 19:58:46,273: INFO pgadmin: >> > ######################################################## >> > 2016-10-03 20:06:49,503: INFO pgadmin: >> > ######################################################## >> > 2016-10-03 20:06:49,503: INFO pgadmin: Starting pgAdmin 4 v1.0... >> > 2016-10-03 20:06:49,503: INFO pgadmin: >> > ######################################################## >> > 2016-10-03 20:35:58,332: INFO pgadmin: >> > ######################################################## >> > 2016-10-03 20:35:58,332: INFO pgadmin: Starting pgAdmin 4 v1.0... >> > 2016-10-03 20:35:58,332: INFO pgadmin: >> > ######################################################## >> > 2016-10-03 20:48:17,717: INFO pgadmin: >> > ######################################################## >> > 2016-10-03 20:48:17,717: INFO pgadmin: Starting pgAdmin 4 v1.0... >> > 2016-10-03 20:48:17,717: INFO pgadmin: >> > ######################################################## >> > >> > I have attached a shot about the pgAdmin right after launching it. >> > >> > I have not installed any other version of PostgreSQL nor previous test >> > release of pgAdmin 4 on my box. >> >> Wow, that really is unhelpful. If you browse into the web/ directory >> in the installation directory, can you please add the following 2 >> lines to config_local.py, then re-run pgAdmin and check/send the >> logfile again? >> >> DEBUG = True >> FILE_LOG_LEVEL = 10 >> >> Thanks. >> >> -- >> Dave Page >> Blog: http://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EnterpriseDB UK: http://www.enterprisedb.com >> The Enterprise PostgreSQL Company > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
<div dir="ltr">I have installed the standalone package but I am getting the exactly same result, even if I extend the config_local.pyproperty file.</div><div class="gmail_extra"><br /><div class="gmail_quote">On 7 October 2016 at 12:22, DavePage <span dir="ltr"><<a href="mailto:dpage@pgadmin.org" target="_blank">dpage@pgadmin.org</a>></span> wrote:<br/><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">No, I agree:-(. Can you please try the standalone pgAdmin package<br /> from <a href="https://www.postgresql.org/ftp/pgadmin3/pgadmin4/v1.0/"rel="noreferrer" target="_blank">https://www.postgresql.org/<wbr/>ftp/pgadmin3/pgadmin4/v1.0/</a> and see if<br /> you get different results?<br/><br /> Thanks.<br /><br /> On Fri, Oct 7, 2016 at 8:38 AM, Laczkóczki Ákos<br /><div class="HOEnZb"><div class="h5"><<ahref="mailto:laczkoczki.akos@gmail.com">laczkoczki.akos@gmail.com</a>> wrote:<br /> > I have addedthe two lines to config_local.py but the result is not saying<br /> > any interesting to me in the log:<br /> ><br/> > 2016-10-07 09:35:20,704: INFO pgadmin:<br /> > ##############################<wbr />##########################<br/> > 2016-10-07 09:35:20,704: INFO pgadmin: Starting pgAdmin 4 v1.0...<br /> > 2016-10-0709:35:20,704: INFO pgadmin:<br /> > ##############################<wbr />##########################<br /> >2016-10-07 09:35:20,704: DEBUG pgadmin: Python syspath:<br /> > ['C:\\development\\tools\\<wbr />postgresql\\9.6\\pgAdmin4\\web',<br /> > 'C:\\development\\tools\\<wbr />postgresql\\9.6\\pgAdmin 4\\bin\\python27.zip',<br/> > 'C:/development/tools/<wbr />postgresql/9.6/pgAdmin 4/venv\\DLLs',<br /> > 'C:/development/tools/<wbr/>postgresql/9.6/pgAdmin 4/venv\\lib',<br /> > 'C:/development/tools/<wbr />postgresql/9.6/pgAdmin4/venv\\lib\\plat-win',<br /> > 'C:/development/tools/<wbr />postgresql/9.6/pgAdmin 4/venv\\lib\\lib-tk',<br/> > 'C:\\development\\tools\\<wbr />postgresql\\9.6\\pgAdmin 4\\bin',<br /> > 'C:/development/tools/<wbr/>postgresql/9.6/pgAdmin 4/venv/Lib/site-packages',<br /> > 'C:/development/tools/<wbr />postgresql/9.6/pgAdmin4/venv/DLLs',<br /> > 'C:/development/tools/<wbr />postgresql/9.6/pgAdmin 4/venv/Lib',<br /> >'C:\\development\\tools\\<wbr />postgresql\\9.6\\pgAdmin 4\\venv\\DLLs',<br /> > 'C:\\development\\tools\\<wbr />postgresql\\9.6\\pgAdmin4\\venv\\Lib\\lib-tk',<br /> > 'C:\\development\\tools\\<wbr />postgresql\\9.6\\pgAdmin 4\\venv\\Lib']<br/> > 2016-10-07 09:35:20,704: DEBUG pgadmin: Available translations:<br /> > [Locale('fr')]<br />><br /> > On 4 October 2016 at 16:11, Dave Page <<a href="mailto:dpage@pgadmin.org">dpage@pgadmin.org</a>>wrote:<br /> >><br /> >> On Mon, Oct 3, 2016 at 7:53PM, Laczkóczki Ákos<br /> >> <<a href="mailto:laczkoczki.akos@gmail.com">laczkoczki.akos@gmail.com</a>> wrote:<br/> >> > I have the following in the log file: (it is unusable to figure out what<br /> >> > happens)<br/> >> ><br /> >> > 2016-10-03 19:43:28,607: INFO pgadmin:<br /> >> > ##############################<wbr/>##########################<br /> >> > 2016-10-03 19:43:28,607: INFO pgadmin:Starting pgAdmin 4 v1.0...<br /> >> > 2016-10-03 19:43:28,607: INFO pgadmin:<br /> >> > ##############################<wbr/>##########################<br /> >> > 2016-10-03 19:46:55,230: INFO pgadmin:<br/> >> > ##############################<wbr />##########################<br /> >> > 2016-10-0319:46:55,230: INFO pgadmin: Starting pgAdmin 4 v1.0...<br /> >> > 2016-10-03 19:46:55,230: INFO pgadmin:<br/> >> > ##############################<wbr />##########################<br /> >> > 2016-10-0319:58:46,273: INFO pgadmin:<br /> >> > ##############################<wbr />##########################<br/> >> > 2016-10-03 19:58:46,273: INFO pgadmin: Starting pgAdmin 4 v1.0...<br /> >>> 2016-10-03 19:58:46,273: INFO pgadmin:<br /> >> > ##############################<wbr />##########################<br/> >> > 2016-10-03 20:06:49,503: INFO pgadmin:<br /> >> > ##############################<wbr/>##########################<br /> >> > 2016-10-03 20:06:49,503: INFO pgadmin:Starting pgAdmin 4 v1.0...<br /> >> > 2016-10-03 20:06:49,503: INFO pgadmin:<br /> >> > ##############################<wbr/>##########################<br /> >> > 2016-10-03 20:35:58,332: INFO pgadmin:<br/> >> > ##############################<wbr />##########################<br /> >> > 2016-10-0320:35:58,332: INFO pgadmin: Starting pgAdmin 4 v1.0...<br /> >> > 2016-10-03 20:35:58,332: INFO pgadmin:<br/> >> > ##############################<wbr />##########################<br /> >> > 2016-10-0320:48:17,717: INFO pgadmin:<br /> >> > ##############################<wbr />##########################<br/> >> > 2016-10-03 20:48:17,717: INFO pgadmin: Starting pgAdmin 4 v1.0...<br /> >>> 2016-10-03 20:48:17,717: INFO pgadmin:<br /> >> > ##############################<wbr />##########################<br/> >> ><br /> >> > I have attached a shot about the pgAdmin right afterlaunching it.<br /> >> ><br /> >> > I have not installed any other version of PostgreSQL nor previoustest<br /> >> > release of pgAdmin 4 on my box.<br /> >><br /> >> Wow, that really is unhelpful.If you browse into the web/ directory<br /> >> in the installation directory, can you please add the following2<br /> >> lines to config_local.py, then re-run pgAdmin and check/send the<br /> >> logfile again?<br/> >><br /> >> DEBUG = True<br /> >> FILE_LOG_LEVEL = 10<br /> >><br /> >> Thanks.<br/> >><br /> >> --<br /> >> Dave Page<br /> >> Blog: <a href="http://pgsnake.blogspot.com"rel="noreferrer" target="_blank">http://pgsnake.blogspot.com</a><br /> >> Twitter:@pgsnake<br /> >><br /> >> EnterpriseDB UK: <a href="http://www.enterprisedb.com" rel="noreferrer" target="_blank">http://www.enterprisedb.com</a><br/> >> The Enterprise PostgreSQL Company<br /> ><br /> ><br/><br /><br /><br /> --<br /> Dave Page<br /> Blog: <a href="http://pgsnake.blogspot.com" rel="noreferrer" target="_blank">http://pgsnake.blogspot.com</a><br/> Twitter: @pgsnake<br /><br /> EnterpriseDB UK: <a href="http://www.enterprisedb.com"rel="noreferrer" target="_blank">http://www.enterprisedb.com</a><br /> The Enterprise PostgreSQLCompany<br /></div></div></blockquote></div><br /></div>
On Fri, Oct 7, 2016 at 11:58 AM, Laczkóczki Ákos <laczkoczki.akos@gmail.com> wrote: > I have installed the standalone package but I am getting the exactly same > result, even if I extend the config_local.py property file. OK - did you install in the default location? I noticed your original paths were not in the Program Files directory, and I wonder if some of the Windows security is getting in the way. If not, is that something you can try? You can test with the standalone installer to avoid messing with your PostgreSQL installation - obviously you'll need to uninstall pgAdmin first. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
I would like to inform you I have successfully fixed the issue.
Probably the problem was that the name of my user home directory contains space and special characters. So, the exact path which pgAdmin uses for log and reach the pgadmin4.db was the following:
c:\Users\Laczkóczki Ákos\AppData\Roaming\pgadmin4\
I think it wasn't able to reach the pgadmin4.db file because after trying to launch pgadmin the size of the db file was 0.
I have modified the config.py file as the following:
if os.name == 'nt':
DATA_DIR = os.path.realpath('c:/development/tools/PostgreSQL/pgadmin/data')
else:
DATA_DIR = os.path.realpath(os.path.expanduser('~/.pgadmin/'))
So, I changed the DATA_DIR to a custom place which path doesn't contain any special thing and now I am able to launch pgAdmin and it seems it is working fine.
Thanks for your help!
Best regards,
Akos
On 7 October 2016 at 14:47, Dave Page <dpage@pgadmin.org> wrote:
On Fri, Oct 7, 2016 at 11:58 AM, Laczkóczki Ákos
<laczkoczki.akos@gmail.com> wrote:
> I have installed the standalone package but I am getting the exactly same
> result, even if I extend the config_local.py property file.
OK - did you install in the default location? I noticed your original
paths were not in the Program Files directory, and I wonder if some of
the Windows security is getting in the way.
If not, is that something you can try? You can test with the
standalone installer to avoid messing with your PostgreSQL
installation - obviously you'll need to uninstall pgAdmin first.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Hi On Sun, Oct 16, 2016 at 12:23 PM, Laczkóczki Ákos <laczkoczki.akos@gmail.com> wrote: > I would like to inform you I have successfully fixed the issue. > > Probably the problem was that the name of my user home directory contains > space and special characters. So, the exact path which pgAdmin uses for log > and reach the pgadmin4.db was the following: > > c:\Users\Laczkóczki Ákos\AppData\Roaming\pgadmin4\ > > I think it wasn't able to reach the pgadmin4.db file because after trying to > launch pgadmin the size of the db file was 0. > > I have modified the config.py file as the following: > > if os.name == 'nt': > DATA_DIR = > os.path.realpath('c:/development/tools/PostgreSQL/pgadmin/data') > else: > DATA_DIR = os.path.realpath(os.path.expanduser('~/.pgadmin/')) > > So, I changed the DATA_DIR to a custom place which path doesn't contain any > special thing and now I am able to launch pgAdmin and it seems it is working > fine. Good catch! Likely a unicode issue then I'd guess. Does it work if you use: DATA_DIR = u'c:/Users/Laczkóczki Ákos/AppData/Roaming/pgadmin/' ? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
hi,i have the same problem now,but i don't know how to find config.py,can you tell me some details? -- View this message in context: http://postgresql.nabble.com/Cannot-launch-pgAdmin4-tp5924098p5943865.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
Location would be on Windows10 (depending on your platform):
Path: C:\Program Files\PostgreSQL\9.6\pgAdmin 4\web
C:\Program Files\PostgreSQL\9.6\pgAdmin 4\web\config.py
OR
C:\Program Files (x86)\PostgreSQL\9.6\pgAdmin 4\web\config.py
--
Regards,
On Mon, Feb 13, 2017 at 9:59 AM, new_rengar <352283725@qq.com> wrote:
hi,i have the same problem now,but i don't know how to find config.py,can you
tell me some details?
--
View this message in context: http://postgresql.nabble.com/Cannot-launch-pgAdmin4- tp5924098p5943865.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
Thank you very much!I have solve the problem. -- View this message in context: http://postgresql.nabble.com/Cannot-launch-pgAdmin4-tp5924098p5944052.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.