How to install PostgreSQL and start its server in OpenSuse Tumbleweed

Installing the packages
Install the postgresql client, server and contrib. –>contrib provides some extensions that are not yet part of root tree

$ sudo zypper in postgresql postgresql-server postgresql-contrib

Install the optional procedural languages, according to your needs: Perl / Tlc / Python (postgres supports 2.x and 3.x, please check official documentation):

$ sudo zypper in postgresql-plperl postgresql-plpython postgresql-plctl

Initialize the db storage using initdb
Before you can do anything, you must initialize a database storage area on disk. a database cluster is a single directory under which all data will be stored. It’s generally recommendable that the PostgreSQL user own not just the data directory but its parent directory as well.
Note that you must execute the initdb command while logged in as user ‘postgres’.

$ sudo mkdir /home/postgres
$ sudo mkdir /home/postgres/data
$ sudo chown -R postgres /home/postgres
$ sudo su – postgres
$ initdb -D /home/postgres/data

Start the server
Enable postgres server to start at system boot:

$ systemctl enable postgresql

Start postgres server:

$ systemctl start postgresql

Connect to database using default administer account

$ psql -U postgres
Create a new role for yourself with permission to create databases, you should create at least one super user, that is not ‘postgres’ :


To quit: type \q (backward slash + q )

9 Steps to Install and Configure PostgreSQL from Source on Linux TheGeekStuff
DIY: A PostgreSQL database server setup anyone can handle TechRepublic
How install PostreSQL and get started with PostgreSQL OpenSuse Wiki
Need help to setup Postgresql…[Solved]PCLinuxOS Forum
Creating a Database ClusterPostgreSQL 10 Documentation


Connecting WWAN Modem in Linux

As of this writing Linux support about this type of modem isn’t really good. GUI Network Manager doesn’t know such device. You need to configure it manually (in console). The solution that works for me.

$ echo -e “AT^NDISDUP=1,1,\”your_APN_name\”\r” > /dev/ttyUSB0

This command will connect the stick to LTE network.

– You have installed usb_modeswitch package
– the modem created /dev/ttyUSB0
– your modem has no qmi and no mbim. It just works with AT command.


$ su -c dhclient wwan0

This command will acquire IP address for the wwan0 interface.

Various notes:
– When this device connected to internet, your network manager software will recognized the connection as ‘Wired Connection’.
– if your WWAN modem is QMI device, you probably need to use qmcli to configure your device.
– if your WWAN modem is MBIM device, you probably need to use mmcli to configure your device.

How to enable broadband connection with Huawei E3372h on Ubuntu Server
How To Use LTE modem in QMI mode for WAN connection
What is libqmi?
What is libmbim?

How to enable the Ribbon UI [MS Office style] in LibreOffice

To enable the new Ribbon UI
Tools > Options > LibreOffice > Advanced > Enable experimental features (may be unstable)
LibreOffice will then need to restart. After the restart:
View > Toolbar Layout > Notebookbar

To revert the changes
Click some strange icon in top left corner > Options > Advanced > uncheck “Enable experimental features (may be unstable)”

LibreOffice 5.3 Ships with Experimental Office-Like Ribbon UI
Microsoft Office Ribbon UI Is Coming to LibreOffice

Using dd to Create a Bootable USB Linux System from .iso File

This short tutorial assumes you build the bootable USB from a Linux system (not from Windows or Mac).
– First make an hybrid ISO from your distro .iso file using isohybrid tool. This step isn’t required if your .iso  are already a hybrid.

$ isohybrid your_iso_file.iso

You might see an error when issuing the command

Warning: more than 1024 cylinders (1620).Not all BIOSes  will be able to boot this device

Don’t worry about it.The warning refers to very old BIOSes.

– Then use dd to write that hybrid ISO to your USB drive.

$ dd if=your_iso_file.iso of=/dev/sdX

Replace the your_iso_file with the name of your .iso file.
Replace the /dev/sdX with the path to the USB drive. Note: the path to the USB drive (/dev/sdX) you want to write to must not contain a partition letter.  So it should look like /dev/sdb not /dev/sdb1.
Also, the dd command does not provide indicator for progression while it is running in the console. Just wait for a little while.

Create USB Boot Stick | PCLinuxOS forum
HOWTO: Create a bootable Linux Media using the dd Command |

Youtube’s HTML5 Player and 1080p in Firefox(Linux)

1.Activating HTML5 player
As of this writing it is not activated by default in Firefox. It has something to do about Media Source Extensions, not activated by default in Firefox.
Go to and “Select the HTML5 player” to activate the HTML5 player.

2.Get the 1080p stuff
To get Full HD resolution you need to enable both Media Source Extensions in general and MSE + WebM in Firefox.
-Type about:config in the address and Click “I’ll be careful, I promise”
– Type mediasource in searchbox. Double-click both media.mediasource.enabled and media.mediasource.webm.enabled in order to change their value to “true”. Continue reading “Youtube’s HTML5 Player and 1080p in Firefox(Linux)”

Solution for Virtualenv Error : ‘Unable to Execute bla bla Permission Denied ‘

So I got this error when creating a virtualenv on a different partition other than my /home folder.

ERROR: The executable myenv/bin/python3.4 could not be run: [Errno 13] Permission denied

Turns out this problem related to the default permission when creating a partition which didn’t enable exec option on my partition. So, I enable the exec option by editing /etc/fstab .

# Entry for /dev/sda7 :
/dev/sda7 /media/sda7 ext4 user 1 2


# Entry for /dev/sda7 :
/dev/sda7 /media/sda7 ext4 user,exec 1 2

Note the addition of ‘exec’.

strange permissions problems for virtualenv python executable (lubuntu-12.10) | StackOverFlow