Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

PostgreSQL instalation

Hello.

I have not found any documentation about the instalation of osTicket in a PHP+PostgreSQL environment.
Is there any option available?
Is easy to customize the general installation to work with PostgreSQL?

Thank you in advance.
Muchas gracias a todos.:)

Comments

  • osTicket doesn't currently support Postgress and, as far as I know, we have no plans of adding it, but if there were enough demand for it, we would certainly consider it.
  • I've never used postgreSQL, but I would assume that, like most DBMS, it sticks fairly closely to standard SQL. osTicket seems to use database abstraction fairly well, so I don't imagine it would be too difficult to re-write the mySQL syntax into postgreSQL, MSSQL, or any other language, if you were so inclined.

    Is there a postgreSQL version of a WAMP server?
  • PostgreSQL instalation

    Perfect Do you know something about the other question? It would be really cool to build a database structure and then convert it to postgresql or mysql without problems..
  • This sound like the permissions on the data directory are such that the postgres (Windows) user cannot write to that directory.

    The postgres user is be a non-admin and you are trying to put the data directory into the "Program Files" directory which is write protected for non-admins. So you should either create the data directory outside the program directory (highly recommended) or set the permissions on the data directory so that the postgres user (or "Everybody") can write to it.

    Then try to run initdb manually.

    --------------------------------------------------------
  • edited January 2016
    I know this is a really old thread, but just wanted to offer this in case it helps someone. The complications involved in switching between the popular RDMS systems such as MySQL, PostgreSQL, Oracle, and Microsoft SQL Server would be around:
    1. Whether the app uses database-specific functions or a generic API. 
    2. Differences between built-in functions.
    3. If the app uses stored functions and procedures--these use db-specific languages and constructs.
    In the case of osTicket, from my 5 minute review (so take it for what it's worth) I did not find any stored functions and procedures in the osticket mysql database, so good there--that's usually the big one that can make a database migration difficult.

    osticket uses an ORM based on the Django ORM. This is good in the sense that the actual database interaction is abstracted away from specifics of MySQL. The generic database functions are defined in include/mysqli.php, and you guessed it--they are wrapped around mysql specific methods.

    So, again 5 minute review, but you'd have to create your own postgresql.php that emulates all of the methods in mysqli.php. That alone may get you 99% there. So at least my initial take says it would not be a huge project.

    BUT, I'm not sure why I'd bother considering how easy it is to just use MySQL. I'm a huge PostgreSQL fan, but if you know how to use and administrate PostgreSQL, your skills translate quite easily to MySQL--so just install MySQL and roll with it.

    Of course if you are in a large organization that has a team of database admins with PostgreSQL specialized tools, backup strategies, etc., I can understand the desire for this.

    If I was setting up osTicket for a large organization, I'd use Amazon's Aurora database offering in their AWS RDS service. It's designed to be 100% MySQL compatible and offers about 5x performance, automatic backups, automatic growth in 10G SSD chunks, redundancy, etc. Pretty stinkin' amazing.
  • "osticket uses an ORM based on the Django ORM."

    Correction, osTicket is moving towards using an ORM based system.  It's not there yet.
Sign In or Register to comment.