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’ :

# CREATE ROLE WITH CREATEDB LOGIN PASSWORD ;

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

Source:
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

Advertisements

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.
First

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

This command will connect the stick to LTE network.

Assuming:
– 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.

Then

$ 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.

Source:
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
First:
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)”

Source:
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.

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