This topic is locked

V11 Can't seem to connect to POSTGRE database where projects are stored

8/1/2025 3:53:00 PM
ASPRunner.NET General questions
M
MSchell author

ASPRunner.NET V11 Build 43602 in Windows.

Trying to set up POSTGRE Admin to be able to back up my projects off of my local PC. Can't seem to connect to POSTGRE

img alt

Tried using this

  1. PHPRunner/ASPRunner.NET database location.

In version 11 projects are stored in the database as opposed to files. Version 11 installs Postgre database server and stores project data there. A bit later will add an option to store projects in any database of your choice. How can you connect to the default project storage database.

Database type: Postgre
Server: localhost
Port: 14297
Username: phprunner
Password: phprunner
Database: phprunner

Get the failure in the attached image.

ChatGPT 8/1/2025

It looks like you're having trouble connecting to the PostgreSQL database used by ASPRunner.NET. Here are several steps you can follow to troubleshoot and resolve the issue:

  1. Check PostgreSQL Service: Ensure that the PostgreSQL service is running on your machine. You can check this by going to the Services app in Windows and looking for the PostgreSQL service. Make sure it's started.


  2. Verify Port Number: You mentioned using port 14297. By default, PostgreSQL uses port 5432. If you've changed it during installation, make sure that it is indeed set to 14297. You can verify this in the PostgreSQL configuration file (usually located at C:\Program Files\PostgreSQL\<version>\data\postgresql.conf).


  3. Database Credentials: Double-check the username and password you are using. Ensure that the user phprunner exists and has the appropriate permissions to access the phprunner database. You can check this using a PostgreSQL client like pgAdmin or using the command-line interface.


  4. Firewall Settings: Ensure that your firewall is not blocking the connection to the PostgreSQL server. You may need to add an exception for PostgreSQL in your Windows Firewall settings.


  5. Connection String Format: Ensure that you are using the correct connection string format. For PostgreSQL, it usually looks like this:

    Host=localhost;Port=14297;Username=phprunner;Password=phprunner;Database=phprunner;

    If you're using a specific client software, ensure that it supports this format.


  6. Test Connection Using a Client: Use a PostgreSQL client like pgAdmin or DBeaver to test the connection to your PostgreSQL database with the same credentials. This can help identify if the issue is with the ASPRunner.NET connection or with the database itself.


  7. Check for Error Messages: If there are any error messages displayed when you try to connect through ASPRunner.NET, take note of them. They can provide clues about what might be wrong.


  8. Database Logs: Check the PostgreSQL logs for any connection errors. The logs can usually be found in the pg_log directory inside the PostgreSQL data directory.


  9. ASPRunner.NET Forums: If you still can't resolve the issue, consider posting your question on the ASPRunner.NET forums, as the community there may have encountered similar issues.



By following these steps, you should be able to identify the reason for the connection failure and resolve the issue. If you need further assistance, feel free to ask!

M
MSchell author 8/1/2025

I got connected by opening my project.

How can I back all of this up to an external source?

Sergey Kornilov admin 8/2/2025

Built-in database server only runs when ASPRunner.NET itself is started. Start ASPRunner.NET and backup your database. You can also also use your own database for this purpose.

Yet another option is to use version 11.1 and backup projects using a source control system like SVN or git. This can be configured to be executed every time you save the project.
https://xlinesoft.com/blog/2025/06/17/version-11-1-release/