• Home
• Programming Reference
• Linux Reference
• Windows XP Reference
• Reference
• Server Setup Checklist

Slackware Installation Checklist

DISCLAIMER:  This installation guide is essentially my own personal checklist and tips for installing Slackware on the Desktop.  As such, it may not detail every step required nor necessarily reflect best practices (and of course your configuration tastes and software needs will differ).

It may be beneficial to read though this whole thing first before starting:   there are a few spots where I describe alternatives to earlier steps that you may prefer.

This describes installation for Slackware64 but will be largely applicable to the 32 bit version.

The older versions of this checklist are available here:

• Slackware 13.37 Installation Checklist
• Slackware 13.1 Installation Checklist
• Slackware 12.2 Installation Checklist

Slackware 14.1 Installation Checklist

1. Prepare all CDs, DVDs, USB sticks, network drives, local partions as required:
   • Slackware and optionally Slackware boot floppy or USB flash drive.  It is best to purchase from the Slackware Store (to support Slackware) or download the torrent (to share bandwidth).
   • Read Slackware-HOWTO and usb-and-pxe-installers/README-USB.TXT (for USB boot disk) found on the Slackware DVD.
2. If you haven't already done so, join the Slackware Mailing Lists
   • Send an email to Slackware Announce to subscribe to the slackware new release and major updates mailing list.
   • Send an email to Slackware Security to subscribe to the slackware security issues mailing list.
3. Check your installation DVD (or the files/ISO on disk) from the DVD root directory:
   md5sum -c CHECKSUMS.md5 | grep -E 'FAIL|WARN'
4. Boot from Slackware Disk (although it can be handy to partition the hard drives first if this is not an initial installation to make sure you get it right).
5. Partion Hard Drives in preparation for installation.
   • Run fdisk -l to determine connected drives.
   • Run cfdisk /dev/<drive> (usually sda) to partition the drives.
     Note: if using an SSD you will want to use fdisk /dev/<drive> as cfdisk will not align the partition correctly (hurts performance).
   • Create file systems on the new partitions (Slackware setup can also do this for you but you will have to add the labels yourself later):
     • mkswap -L SWAP /dev/<drive> for SWAP partition (usually best at the beginning of the drive for access speed, but on modern systems with gobs of RAM you may not want to bother - especially if using a pricey SSD).
     • mkfs.ext3 -L BOOT /dev/<drive> for /boot partition.  EXT2 is not a bad idea for SSD drives and you can use EXT4 with LILO.
     • mkfs.ext4 -L ROOT /dev/<drive> for / partition.
     • mkfs.ext4 -L HOME /dev/<drive> for /home partition.
     • mkfs.xfs -L MEDIA /dev/<drive> for an XFS media partition.
       NOTE:  XFS is probably best only if you have a UPS (or are using a laptop) as it is susceptible to data loss (usually files written since last mount) during a power failure.  Use EXT4 for more safety at the expense of slower access and less efficient storage space (this really only applies to the larger files usually found on MEDIA drives; use EXT4 for large normal drives).
6. Boot from Slackware Disk/USB Stick (if you haven't done so already) and run setup.
7. If you want to use grub or you skipped the LILO step (you can also do this later) run:
   • grub-install /dev/sda
   • grub-mkconfig -o /boot/grub/grub.cfg (you will probably want to customize /etc/defaults/grub and the files in /etc/grub.d later and re-run this).
8. Edit key configuration files as required (the easiest way is to reboot into the existing Linux installation and mount from there):
   Another alternative is to boot into the new Slackware installation (first ensure there is no direct internet connection).
   • /etc/hosts:

     	127.0.0.1	localhost
     	xxx.xxx.xxx.xxx	local intranet servers and/or quick shortcuts

   • /etc/hosts.deny:

     	ALL:ALL

   • /etc/hosts.allow:

     	ALL:127.0.0.1
     	#configure below to match your local network - the below is probably the most common:
     	ALL:192.168.1.

   • /etc/inetd.conf:
     • Comment out (add a # in front of) time and comsat.
   • /etc/fstab
     • Change defaults to defaults,noatime for local drives.
     • Add discard to SSD drive partition options to enable TRIM support.  Reference Tuning Solid State Drives in Linux for more detail about using SSDs.
     • Add tmpfs mount(s): (ex. <fs_path> tmpfs uid=<user_name>,gid=users,size=64M,mode=0777 0 0 ).
       For Systems with gobs of ram, add the following lines (technically, /var should be preserved between boots, but losing /var/tmp on reboot should be fine:  saves a lot of writes to SSDs and /tmp in ram makes for fast compile times).

       	tmpfs	/tmp		tmpfs	size=8G,mode=0777	0	0
       	tmpfs	/var/tmp	tmpfs	size=4G,mode=0777	0	0

     • Add nfs mounts: <server_ip>:/<export_path> /<mount_path> nfs rw,hard,intr,noatime
   • /etc/exports
     • /<exported_directory>/ <allowed_ips>(rw,sync,no_subtree_check)
       Some fs types (ex. tmpfs) will also require fsid=<small_int>.
   • /etc/rc.d/rc.inet1.conf (skip this if using networkmanager)
   • Add the following to /etc/rc.d/rc.inet2 around the NFS, CIFS, and SMB sections to allow skipping when booting with a CUSTOM kernel parameter.

     	if grep -q CUSTOM /proc/cmdline ; then
     	...
     	fi

   • /etc/rc.d/rc.M (rearrange sections to match) if using networkmanager to be earlier in the boot process:

     	# Start networking daemons:
     	if [ -x /etc/rc.d/rc.inet2 ]; then
     		. /etc/rc.d/rc.inet2
     	fi
     
     	# Start D-Bus:
     	if [ -x /etc/rc.d/rc.messagebus ]; then
     		sh /etc/rc.d/rc.messagebus start
     	fi
     
     	# Start wicd or networkmanager:
     	if [ -x /etc/rc.d/rc.wicd -a -x /usr/sbin/wicd ]; then
     		sh /etc/rc.d/rc.wicd start
     	elif [ -x /etc/rc.d/rc.networkmanager ]; then
     		sh /etc/rc.d/rc.networkmanager start
     	fi
     
     	# Mount any additional filesystem types that haven't already been mounted:
     	# mount -a -v 2> /dev/null | grep -v "already mounted"

     
     Suppress MySQL messages as it ends up finishing after boot finished:

     	# Start the MySQL database:
     	if [ -x /etc/rc.d/rc.mysqld ]; then
     		. /etc/rc.d/rc.mysqld start > /dev/null
     	fi

     
     Add a section to mount remote drives when using networkmanager (they will fail earlier):

     	if grep -q CUSTOM /proc/cmdline ; then
     		/etc/rc.d/rc.mount & &> /dev/null
     	fi
     	clear
     	# All done.

   • Add /etc/rc.d/rc.mount (to connect nfs drives once networkmanager has completed connections):

     	#!/bin/sh
     	while ! mount -a -t nfs && (($? == 32)); do
     		sleep 2
     	done

   • /etc/rc.d/rc.local
   • /etc/rc.d/rc.local_shutdown
   • /etc/X11/xorg.conf (not usually required in modern Linux installations unless for the following):
     • When using the nvidia binary driver, run nvidia-xconfig to generate the required xorg.conf (nvidia-xconfig --twinview for multiple monitors).
       NOTE:  This will not be possible until after installing the binary video driver.
     • Add the following in the screen section for (some) big screen TVs using the nvidia binary drivers to solve extra small text issue:

       	Option         "UseEdidDpi" "False"
       	Option         "DPI" "96 x 96"

   • /etc/ssh/ssh_config:

     	Port <custom port number>
     	# ForwardAgent yes
     	Host <trustedhost1> <trustedhost2>
     	ForwardX11 yes
     	ForwardX11Trusted yes

   • /etc/ssh/sshd_config:

     	Port <custom port number>
     	PermitRootLogin no
     	AllowUsers <list of users here>
     	X11Forwarding yes

   • /etc/ntp.conf:

     	server <LAN server> prefer
     	broadcastdelay 0.004

   • /etc/skel/.bash_logout: (also copy to /root)

     	#!/bin/bash
     	#clear screen on logout unless in X session or logged in remotely.
     	if grep -q SSH_CONNECTION /proc/self/environ; then
     		echo -en "\033[1;33mClosing SSH Session...\033[0m"
     	elif grep -q DISPLAY /proc/self/environ; then
     		echo -e "\033[1;33mGoodbye...\033[0m"
     	else
     		CUR_CONSOLE=`fgconsole`
     		clear
     		chvt 63
     		chvt "$CUR_CONSOLE"
     	fi

9. Reboot into new Linux installation.
10. Setup GRUB if it hasn't been done already (and you so desire):
    • Set the desired timeouts (and splash screens, etc.) in /etc/defaults/grub
    • Modify /etc/grub.d/10_linux (of course tailer to your requirements/system):

      		if [ "x$is_first_entry" = xtrue ]; then
      		linux_entry "${OS} X" "${version}" simple \
      		"${GRUB_CMDLINE_LINUX} ${GRUB_CMDLINE_LINUX_DEFAULT}4 ipv6.disable=1"
      		linux_entry "${OS}" "${version}" simple \
      		"${GRUB_CMDLINE_LINUX} ${GRUB_CMDLINE_LINUX_DEFAULT} ipv6.disable=1"
      		linux_entry "${OS} X Home" "${version}" simple \
      		"${GRUB_CMDLINE_LINUX} ${GRUB_CMDLINE_LINUX_DEFAULT}4 ipv6.disable=1 CUSTOM"
      		linux_entry "${OS} Home" "${version}" simple \
      		"${GRUB_CMDLINE_LINUX} ${GRUB_CMDLINE_LINUX_DEFAULT}ipv6.disable=1 CUSTOM"
      
      		submenu_indentation="\t"
      
      		if [ -z "$boot_device_id" ]; then
      		boot_device_id="$(grub_get_device_id "${GRUB_DEVICE}")"
      		fi
      		# TRANSLATORS: %s is replaced with an OS name
      	#     echo "submenu '$(gettext_printf "Advanced options for %s" "${OS}" | grub_quote)' \$menuentry_id_option 'gnulinux-advanced-$boot_device_id' {"
      	fi
      
      	#   linux_entry "${OS}" "${version}" advanced \
      	#               "${GRUB_CMDLINE_LINUX} ${GRUB_CMDLINE_LINUX_DEFAULT}"
      	#   if [ "x${GRUB_DISABLE_RECOVERY}" != "xtrue" ]; then
      	#     linux_entry "${OS}" "${version}" recovery \
      	#                 "single ${GRUB_CMDLINE_LINUX}"
      	#   fi
      
      	list=`echo $list | tr ' ' '\n' | grep -vx $linux | tr '\n' ' '`
      	is_first_entry=false
      	done
      
      	# # If at least one kernel was found, then we need to
      	# # add a closing '}' for the submenu command.
      	# if [ x"$is_first_entry" != xtrue ]; then
      	#   echo '}'
      	# fi
      
      	echo "$title_correction_code"

    • Comment out the following in /etc/grub.d/30_os-prober:

      	# 	if [ "x$is_first_entry" = xtrue ]; then
      	#             cat << EOF
      	# menuentry '$(echo "$OS" | grub_quote)' --class gnu-linux --class gnu --class os \$menuentry_id_option 'osprober-gnulinux-simple-$boot_device_id' {
      	# EOF
      	# 	    save_default_entry | sed -e "s/^/\t/"
      	# 	    printf '%s\n' "${prepare_boot_cache}"
      	# 	    cat <<  EOF
      	# 	linux ${LKERNEL} ${LPARAMS}
      	# EOF
      	#             if [ -n "${LINITRD}" ] ; then
      	#           cat << EOF
      	# 	initrd ${LINITRD}
      	# EOF
      	#             fi
      	#         cat << EOF
      	# }
      	# EOF
      	# 	    echo "submenu '$(gettext_printf "Advanced options for %s" "${OS}" | grub_quote)' \$menuentry_id_option 'osprober-gnulinux-advanced-$boot_device_id' {"
      	# 	    is_first_entry=false
      	# 	fi
      	# 	title="${LLABEL} $onstr"
      	#         cat << EOF
      	# 	menuentry '$(echo "$title" | grub_quote)' --class gnu-linux --class gnu --class os \$menuentry_id_option 'osprober-gnulinux-$LKERNEL-${recovery_params}-$boot_device_id' {
      	# EOF
      	# 	save_default_entry | sed -e "s/^/\t\t/"
      	# 	printf '%s\n' "${prepare_boot_cache}" | sed -e "s/^/\t/"
      	# 	cat <<  EOF
      	# 		linux ${LKERNEL} ${LPARAMS}
      	# EOF
      	#         if [ -n "${LINITRD}" ] ; then
      	#             cat << EOF
      	# 		initrd ${LINITRD}
      	# EOF
      	#         fi
      	#         cat << EOF
      	# 	}
      	# EOF
      	# 	if [ x"$title" = x"$GRUB_ACTUAL_DEFAULT" ] || [ x"Previous Linux versions>$title" = x"$GRUB_ACTUAL_DEFAULT" ]; then
      	# 	    replacement_title="$(echo "Advanced options for ${OS}" | sed 's,>,>>,g')>$(echo "$title" | sed 's,>,>>,g')"
      	# 	    quoted="$(echo "$GRUB_ACTUAL_DEFAULT" | grub_quote)"
      	# 	    title_correction_code="${title_correction_code}if [ \"x\$default\" = '$quoted' ]; then default='$(echo "$replacement_title" | grub_quote)'; fi;"
      	# 	    grub_warn "$(gettext_printf "Please don't use old title \`%s' for GRUB_DEFAULT, use \`%s' (for versions before 2.00) or \`%s' (for 2.00 or later)" "$GRUB_ACTUAL_DEFAULT" "$replacement_title" "gnulinux-advanced-$boot_device_id>gnulinux-$version-$type-$boot_device_id")"
      	# 	fi

    • When retaining an existing boot partition, copy over the appropriate vmlinuz and System.map from /boot.
    • If you have a separate boot partition (for example /dev/sda1): mount /dev/sda1 /boot to point grub2 to the right drive.
    • grub-install /dev/sda
    • grub-mkconfig -o /boot/grub/grub.cfg
11. Upgrade to latest security advisories:
    1. Uncomment your favorite mirror in /etc/slackpkg/mirrors.
    2. slackpkg update gpg (only the first time you run slackpkg)
    3. slackpkg update
    4. slackpkg install-new (optional, but recommended)
    5. slackpkg upgrade-all
12. If using an Nvidia video card you will most likely want the binary drivers and will need to install:
    • libvdpau
    • nvidia kernel module
    • nvidia binary driver
13. Create new User using adduser.
    • Remember to add audio, video, cdrom, plugdev, power to Additional Groups.
14. Reboot and log in as new user.
15. Add ~/.bashrc to set up Konsole logins (of course tailer to your taste):

    	# If not running interactively, don't do anything
    	[ -z "$PS1" ] && return
    	shopt -s autocd cdspell checkjobs shift_verbose
    	# set standard bash prompt //TODO:  add colours for remote or local logins
    	PS1='\u@\h:\w\$ '
    	alias ll='ls -AlFh'
    	if [ -x /usr/games/fortune ]; then
    		/usr/games/fortune -s     # print out short fortunes only
    	fi
    
    	#bash history archive
    	export HISTORYDATE=$(date)
    	trap 'archive_history' EXIT
    
    	archive_history() {
    		HISTORYOLD=${HISTFILE}.archive
    		HISTORYTEMP=/dev/shm/history
    		if  [ x$HISTORYDUMPED = x ]; then
    			echo "**** ${HOSTNAME} ** ${HISTORYDATE} - $(date) ** $(tty) ****" >> "$HISTORYOLD"
    			history -a "$HISTORYTEMP"
    			cat "$HISTORYTEMP" >> "$HISTORYOLD"
    			export HISTORYDUMPED=1
    		fi
    	}

16. Run startx:  To use a different window manager than specified during setup, run xwmconfig.
17. Setup KDE:
    • Add PS1=\u@\h:\w\$ to Konsole environment if konsole prompt is missing (or see alternative above).

    • ---

      Current progress

      ---

    • Install Custom Colour Scheme (QtCurve Preview Dialog Screenshot) - this dark theme works if you have default colour text on a dark background, but the green text is most definitely is not to most people's taste (white looks nicer at the expense not being able to see text on white backgrounds in some poorly behaved applications).
    • Install QtCurve for customizing the UI
      • Install KDE Widget Styles
      • Install GTK2 Widget Styles
      • Install gtk-chtheme.
      • Import the QtCurve Settings from the QtCurve Configure... Dialog (Screenshot).
18. Setup Firefox:
    1. Change about:config settings:
       • Change network.dns.disableIPv6 to true to speed up lookups when IPv6 is not available.
       • Change network.proxy.socks_remote_dns to true to use remote DNS over socks proxies.
       • Change browser.search.showOneOffButtons to false to disable 1 click search and restore classic behaviour (especially if you use keyboard naviation).
    2. Copy the Slackbuilds.org search plugin into your profile searchplugins directory.
    3. Install Flash Player
       • If you have an nvidia card, you can force 3D accelerated video decoding on:
         /etc/adobe/mms.cfg:

         	EnableLinuxHWVideoDecode=1
         	OverrideGPUValidation=true

    4. Install Extensions:
       • Mozilla Addons Search
       • Better Privacy
       • Duplicate this Tab
       • Extended Statusbar
       • Flagfox
       • Flash and Video Download
       • Ghostery
       • Image Zoom
       • Noscript
       • Online Translator Toolbar
       • QuickProxy
       • Secure Login
       • Toolbar Buttons
       • ViewAbout
       • KnightRider 2008 Theme.
19. Setup Thunderbird:
    1. Install Thunderbird from -Current
    2. Change mail.tabs.autoHide to true.
    3. Install Extensions:
       • Canadian English Dictionary
       • ChromEdit Plus
       • Clean Subject
       • CompactHeader
       • FoxyProxy Basic
       • Lightning
       • Lookout
       • Maximize Message Pane
       • MoreFunctionsForAddressBook
       • New Mail Attention
       • OpenAttachmentByExtension
       • SmartTemplate
         • Set the Reply template (gives reply header similar to MS Outlook):

           
           	<hr style=color:#B5C4DF><small style='color:"black";'>
           	<b>From:</b> %from%
           	<b>Sent:</b> %datelocal%
           	<b>To:</b> %to%{
           	<b>CC:</b> %cc%}{
           	<b>Subject:</b> %subject%}
           	</small><br>

         • Set the Forward template:

           
           	<hr style=color:#B5C4DF><small style='color:"black";'>
           	<b>From:</b> %from%
           	<b>Sent:</b> %datelocal%
           	<b>To:</b> %to%{
           	<b>CC:</b> %cc%}
           	</small><br>

       • Toolbar Buttons
       • Install Mail Tweak.
       • Install Mail Redirect.
    4. To create a white background/black text foreground with highlighted indenting levels (for easier viewing of replies) add the following to <profile directory>/chrome/userContent.css:

       	body {color:#000000;background-color:#FFFFFF}
       	.moz-text-plain {color:#000000;background-color:#FFFFFF}
       	blockquote[type=cite] {color: navy !important;background-color: RGB(245,245,245) !important}
       	blockquote[type=cite] blockquote {color: maroon !important; background-color: RGB(235,235,235) !important;}
       	blockquote[type=cite] blockquote blockquote {color: green !important; background-color: RGB(225,225,225) !important;}
       	blockquote[type=cite] blockquote blockquote blockquote {color: purple !important; background-color: RGB(215,215,215) !important;}
       	blockquote[type=cite] blockquote blockquote blockquote blockquote {color: teal !important; background-color: RGB(205,205,205) !important;}

       Alternatively, the Quote Colors extension performs a similar task.
20. Install apcupsd:
    • Add to /etc/rc.d/rc.local:

      	if [ -x /etc/rc.d/rc.apcupsd ]; then
      		/etc/rc.d/rc.apcupsd start
      	fi

    • Change the last section in /etc/rc.d/rc.6 (that begins with if [ -x /sbin/genpowerd ]; then) to:

      	# This will cause the UPS to kill the power supply after a configurable number
      	# of seconds (see the apcupsd.conf file).  This is important for situations
      	# where the mains power comes back before the UPS batteries are completely
      	# dead.
      	if [ -f /etc/apcupsd/powerfail ]; then
      		echo
      		echo "apcupsd will now power off the UPS"
      		echo
      		/etc/apcupsd/apccontrol killpower
      		echo
      		echo "Please ensure that the UPS has powered off before rebooting."
      		echo "Otherwise, the UPS may cut the power during the reboot."
      		echo
      		halt -f -p         # power down the system if the hardware is capable
      	fi

    • Set the lockfile location in /etc/apcupsd/apcupsd.conf to /dev/shm (this creates the lockfile in RAM as it sometimes is not deleted properly and prevents apcupsd from starting).
21. Set up SSH Keys:
    • Make sure ~/.ssh has 700 permissions
    • ssh-keygen -t rsa -b 4096
    • Copy key to server:
      ssh-copy-id <username>@<host> -p <port>
22. Install wxPython dependency:
    • Install FileZilla FTP Client.
    • Install p7zip Compression Utility.
      • Pass GUI=yes to the Slackbuild.
23. Install unrar.
24. Install kchmviewer.
25. Install filelight.
26. Install htop Interactive Process Viewer.
27. Install lshw Hardware Lister.
28. Install Opera Web Browser.
29. Install Libre Office:
    • Install British English Language Package (reasonably close to Canadian English).
30. Install lyx Document Processor.
31. Install libdvdcss DVD Library.
32. Install vobcopy DVD Backup Tool.
33. Install VLC Media Player.
34. Install xautomation X server scripting.
35. Install xbindkeys.
36. Install Skype.
37. Install Patool archive manager.
38. Install Libav Gstreamer Plugin for HTML5 video in Firefox.
39. Install the generic AMD64 VirtualBox.
40. Configure PERL:
    • Install cpanm
      cpan App::cpanminus
    • Install File Find
      cpanm File::Find::Rule
    • Install Date Manip
      cpanm Date::Manip
    • URL Safe Base64
      cpanm MIME::Base64::URLSafe
    • Install Text Formatter
      cpanm Text::Autoformat
    • Install Excel Reader
      cpanm Spreadsheet::ParseExcel
    • Install Excel Writer
      cpanm Spreadsheet::WriteExcel
    • Install Excel Date Parser
      cpanm DateTime::Format::Excel
    • Install Email
      cpanm Email::Sender
    • Install Email Mime
      cpanm Email::MIME
    • Install Email Mime HTML:
      • Make sure Test::Pod, Test::Pod::Coverage, URI::file are installed.
      • Install LWP::UserAgent
        cpanm LWP::UserAgent
      • Install CreateHTML
        cpanm Email::MIME::CreateHTML
      • Install MIME::Base64
        cpanm MIME::Base64
      • Install Authen::SASL
        cpanm Authen::SASL
    • For Connecting to SQL Server:
      • Install unixODBC Driver.
      • Install freetds Tabular Data Stream protocol library.
      • Install DBD::ODBC
        cpanm DBD::ODBC
      • Configure /etc/odbc.ini:

        [NAME]
        Description = NAME FOR CONNECTION
        Driver = /usr/lib64/libtdsodbc.so
        Server = IP.ADDRESS
        Database = DB
        Port = 1433
        TDS_Version = 7.2
        try domain login = yes
        try server login = yes
        nt domain = DOMAIN
        	

    • For connecting to Oracle:
      • Install Oracle Instantclient:
        • Download instantclient-basic-linux.x64
        • Download instantclient-sqlplus-linux.x64
        • Download instantclient-sdk-linux.x64
        • Unzip as root and copy to /usr/lib64/instantclient (only need the include directory from the sdk)
        • cd /usr/lib64/instantclient
        • ln -s libclntsh.so.11.1 libc1ntsh.so
        • ln -s libocci.so.11.1 libocci.so
        • ln -s /usr/lib64/instantclient/sqlplus /usr/bin/sqlplus
        • Create /etc/profile.d/oracle.sh:

          #!/bin/sh
          export ORACLE_BASE="/usr/lib64/instantclient"
          export ORACLE_HOME="${ORACLE_BASE}"
          export LD_LIBRARY_PATH="${ORACLE_BASE}"
          export TNS_ADMIN=/etc/oracle/

        • copy tnsnames.ora to /etc/oracle/
      • export C_INCLUDE_PATH="/usr/lib64/instantclient/include"
      • Install DBD::Oracle
        cpanm DBD::Oracle
    • For Creating Charts:
      • cpanm ExtUtils::Depends
      >cpanm ExtUtils::PkgConfig
      • cpanm Chart::Clicker
41. Install PostgreSQL:
    • Install PHP Postgres Connector.
    • Extract the PHP Source code from above.
    • ./configure --with-pdo-pgsql=shared,/usr
    • make (not make install)
    • cp -p modules/pdo_pgsql.so /usr/lib64/php/extensions/
    • Add extension=pdo_pgsql.so to php.ini
    • Run initdb -D /var/lib/pgsql/9.4/data --locale=en_CA.UTF-8 -A md5 -W" as postgres user.
    • Edit /var/lib/pgsql/9.4/data/pg_hba.conf to set user permissions (and any settings in postgresql.conf as desired).
    • createuser -P -U postgres -W <user>
    • createdb <db> -O <user> -U postgres -W
    • Restore database:
      1. Decrypt gpg file
      2. mv <file> db.tar.xz
      3. unxz db.tar.xz
      4. pg_restore db.tar -U <user> -d <DB> (created earlier using pg_dump <db> >)