Actually this wasn’t as big of a hangup as I thought and I’d like to post a reply to hopefully help others that run into this issue -
Creation of the “create_xwiki_database.sql” is incredibly simple. I realized it was only a byte size file, so very small probably only a few lines. Within the video the guy says that he “grabbed the file off of the XWiki website” but this isn’t at all necessary and a bit misleading since it’s not on the XWiki website as far as I know. Regardless, this doesn’t really change anything as I explain below /.
Just go into Notepad++ and type the exact details that show up after he opens the query tool and inputs the *.sql file at around 2.04 into the youtube video. Here is the text to input into Notepad++ -
CREATE DATABASE xwiki
WITH OWNER = “XWikiDBOwner”
ENCODING = ‘UNICODE’
TABLESPACE = pg_default;
I was under the impression before seeing the size of the file that this went on but it doesn’t, it’s very straight forward and a small little file to create.
Once you have this info in Notepad++ just save it as a *.sql file and it will create the same file that is shown in the video.
Repeat this process for the “grant_schema.sql” file and input them both into your database with the above file first and then “grant_schema.sql” second. Press “F5” or the play button in pgAdmin after importing the files and then right click on the database and refresh it (just as he says in the video).
So apologies I thought this was creating the whole DB but it’s more a small template prior to creating the XWiki DB. It’s just a simple, four or so line *.sql file that can easily be made in Notepad++.
For reference here is the youtube video I’m talking about that can be found in the installation page of XWiki in the “Other Installation Methods”.
It’s found within the “XWiki in Windows - PostgreSQL - Tomcat 9 - Waffle” link.
Any questions about this plz reply and I’ll see if I can help. Have a good 1.