Docker postgres db to local volume/drive for persistent storage permanently

Hi all,

Today, I would be explaining the way to maintain the DB with data persistent when connecting to docker.

System Status

Postgresql DB container is in Docker
Windows 10 PC
Linux containers

Issue

Whenever I restart docker/PC the database wiped off due to container is stopped.

Solution

Create a docker volume

Syntax: docker volume create <>
Example: docker volume create pgdata

Start the container with volume option

Syntax: docker run --rm --name <> -e POSTGRES_PASSWORD=<> -d -p 5432:5432 -v <>:/var/lib/postgresql/data <>
Example: docker run --rm --name pgcontainer -e POSTGRES_PASSWORD=MyPassword -d -p 5432:5432 -v pgdata:/var/lib/postgresql/data postgres

Now, you can run all your database commands

Upon restart also, your data should be safe.

Thanks for reading the blog post.

Please send your feedback and comments to psrdotcom@gmail.com

Sony Xperia L Jellybean 4.2.2 Update Speaker Volume and Mobile Internet Data Connectivity Problem and Solutions

Hi all,

I have updated my sister’s phone from Jellybean 4.1.2 to Jellybean 4.2.2.

She found two problems,

Problems

1) Internet Mobile Data is not working

2) Speaker Volume is very low

Solutions

1) Install “Internet Settings” from Settings->Xperia option. It will installs and activates your mobile data

2) After update manually Switch off and Switch On the device

 

Simple but vital solutions for any Sony customer

 

Please feel free to send your comments and feedbacks to psrdotcom@gmail.com

Blogger Labels: Sony,Xperia,Jellybean,Update,Speaker,Volume,Mobile,Internet,Data,Problem,problems,Install,option,Switch off,Switch On,Simple,customer,comments,Solutions

Mount TrueCrypt Volume with Read and Write File Permission for Users and Groups

Hi friends,

I have been working on Ubuntu from a long time. Recently I am exploring on TrueCrypt and I faced the following issue. After searching lot of websites and forums, I made a solution which worked for me perfectly.

Objective:
TrueCrypt volume copied data should be available to all when its mounted.

Usual Procedure:
Mount the TrueCrypt volume in Ubuntu
Copy some data to the volume
Change file permissions to other users or groups
Other users should be able to view the data from the volume when mounted

Hiccup(Problem):
After mounting the TrueCrypt Volume the directory permissions are changed and fixed to 700 (rwx --- ---). i.e. No access to groups and others.
Changing the directory permissions and changing the ownership will not be applied.
So, other groups and others cannot access the data.

Solution:
While mouting the TrueCrypt volume we need to specify the file system type and give permission to user[s] and/or group[s] with umask.

Please find the syntax and example below

Syntax:
$sudo /usr/bin/truecrypt -t --filesystem={filesystem_type} --fs-options={rwx},uid={userid},gid={groupid},umask={ugorwx} {your_tc_volume} {mounting_folder}

Example:
$sudo /usr/bin/truecrypt -t --filesystem=vfat --fs-options=rw,uid=1000,gid=1000,umask=022 tc1.tc /mnt/folder1

Thanks for visiting my blog.

Please send your feedback and comments to psrdotcom@gmail.com