2019년 11월 17일 일요일

WinSCP 기부

나는 리눅스(Linux)를 많이 사용하는 편이다.
회사에서도 사용하고, 개인적으로도 사용하고 있다.

그러다 보니 자연스럽게, SFTP를 많이 사용하게 된다.
리눅스에서는 SFTP에 대해 기본적으로 이렇게 저렇게 잘 지원을 해주는 편인데,
윈도우는 그렇지 않다.

그래서 윈도우에서는 WinSCP를 설치해서 사용하고 있다.
기능도 잘 되고, 인터페이스도 깔끔하고, 무료이기 때문이다.

저번 Ubuntu,Thunderbird 기부 이후 문득,
또 다시 너무 신세만 지고 살아온게 아닌가 라는 생각이 들었다.
http://kimchki.blogspot.com/2017/10/ubuntu.html
http://kimchki.blogspot.com/2018/10/thunderbird.html

그래서, 기부를 하기로 했다.
https://winscp.net/eng/donate.php


기부를 하면 어떠한 혜택이 주어지는지에 대한 설명이 나온다.


donation 버튼을 클릭하면, 어떠한 방식으로 기부할지 선택하라고 한다.
제일 간단하고 편리한 PayPal을 이용했다.


$9.00 금액을 기부할 것이다 라는 내용이 나온다.
"Leave a note to WinSCP team"을 클릭하면, 메세지도 남길 수 있다.


Fighting !!!


오~ 고맙단다 ㅋㅋ


PayPal 계정에 거래 내역이 뜬다.


기부를 하면, 기부자 명단에 자동으로 올라간다.
방금 기부해서, November 2019 명단에서 맨 끝에 올라갔다.
"Do It" ??? 아,,, 내가 예전에 PayPal 을 Do It 으로 해놔서,,, 뭔가 이상하게 되었군.

기부를 하니, 뿌듯하다.


뭔가 감사의 표시를 한거 같아서 좋다.
많은 사람들을 위해, WinSCP 가 계속 잘 발전했으면 좋겠다.

Red Hat Enterprise Linux 8.1 (RHEL 8.1) 릴리즈 (2019.11.05)

2019.11.05 에 Red Hat Enterprise Linux 8.1 (RHEL 8.1) 릴리즈 되었다.

8.0 이후 6개월만에 업그레이드 되었다.

뭔가 업그레이드가 되었다고 하니, 일단 다운로드 해야겠다.

https://developers.redhat.com/products/rhel/download
이곳에서 iso 를 다운로드 받을 수 있다.


해당 주소로 이동하면, 다운로드 할 수 있는 링크가 나온다.

VersionRelease DateDescriptionDownload
8.1.02019-11-05DVD iso
Boot iso
DVD iso
Boot iso

이렇게 친절하게 표도 퍼왔다.



출처
https://www.redhat.com

2019년 11월 13일 수요일

자격증 EDB Postgres Advanced Server Professional Certification 10




EnterpriseDB 에서 발급하는



EDB Postgres Advanced Server 10 Professional Certification

This Certification assesses and certifies a database professional’s skills needed to perform more advanced DBA responsibilities for maintaining and managing EDB Postgres Advanced Server servers and applications successfully in a production environment.

Competencies: The EDB Postgres Advanced Server Professional Certification requires competence in the following:

  • EDB Postgres Advanced Server Advanced Features and Tools
  • SQL Tuning
  • Performance Tuning
  • Performance Benchmarking
  • Using Extension Modules
  • Table Partitioning
  • Connection Pooling
  • Cloning a Database
  • Streaming Replication
  • Monitoring
  • Database Security
  • Upgrading Best Practices
Candidates to the EDB Postgres Advanced Server Professional Certification exam are required to:
  1. Pass the EDB Postgres Advanced Server Associates Exam with a score of 70% or greater
  2. Complete the associated EDB training course: EDB Postgres Advanced Server DBA Advanced
These pre-requisites provide the minimum knowledge of concepts and skills required to successfully achieve this certification.

Exam Details:
Test Location: On-line
Format: Multiple choice
Length: 1 hour
Minimum Passing Score: 80%
Access Period: Take anytime within 6 calendar
weeks of your purchase.
Prerequisites: 
  Course: EDB Postgres Advanced DBA Administration
  Associate Level Certification: EDB Postgres Advanced Server Associate Certification
Badge: 
  EDB Certified Professional





출처
https://www.enterprisedb.com/ko/training/postgres-certification
https://www.enterprisedb.com/ko/free-postgres-training
https://www.enterprisedb.com/ko/training/learning-paths
https://www.enterprisedb.com/ko/training/certification-faq

















자격증 EDB Postgres Advanced Server Associate Certification 10



EnterpriseDB 에서 발급하는



EDB Postgres Advanced Server 10 Associate Certification

This exam assesses and certifies a database professional’s skills necessary for maintaining and managing EDB Postgres Advanced Server servers and applications in a production environment. Affirms knowledge and capabilities in leveraging open source based database technology for enterprise environments.

Competencies: The EDB Postgres Advanced Server Associate Certification requires competence in the following:

  • EDB Postgres Advanced Server System Architecture
  • Database Objects and Hierarchy
  • Install, Create and Administer EDB Postgres Advanced Server
  • SQL Commands, EDB-PSQL, and EDB*Plus
  • EDB Postgres Enterprise Manager Client
  • Configuration Settings and Parameters
  • Creating and Managing Databases and Database Clusters
  • User Tools for Administration
  • Tablespaces – Creating and Managing
  • Users, Groups, and Assigning Privileges
  • Security Settings, Authentication and Authorization
  • EDB*Loader
  • Oracle Compatibility
  • Migrating Oracle Database Objects to EDB Postgres Advanced Server
  • Proactive Maintenance
  • Improving Performance
  • Backup and Recovery Strategies
  • Moving Data
Candidates to the EDB Postgres Advanced Server Associate Certification exam are required to complete the associated EDB training course EDB Postgres Advanced Server Database Administration Essentials. This class presents the minimum knowledge of concepts and skills required to achieve this certification.

Exam Details:
Test Location: On-line
Format: Multiple choice
Length: 1 hour
Access Period: Take anytime within 6 calendar
weeks of your purchase.
Prerequisites:
Course:Postgres Administration Essentials v10 
(FREE eLearning class as part of the Free Postgres Training eSubscription) 

OR
EDB Postgres Advanced Server Database Administration Essentials v10(instructor-led)
Badge: 
EDB Certified Associate









출처
https://www.enterprisedb.com/ko/training/postgres-certification
https://www.enterprisedb.com/ko/free-postgres-training
https://www.enterprisedb.com/ko/training/learning-paths
https://www.enterprisedb.com/ko/training/certification-faq











자격증 PostgreSQL Professional Certification 10


EnterpriseDB 에서 발급하는



PostgreSQL 10 Professional Certification

This exam is the definitive standard for PostgreSQL professionals. This certification assesses and certifies a database professional’s ability to work in demanding, large-scale, real-world production environments.

The PostgreSQL Professional Certification requires competence in the following:

  • Database Monitoring
  • SQL Tuning
  • Performance Tuning
  • Performance Benchmarking
  • High Availability
  • Connection Pooling
  • Table Partitioning
  • Extensions
  • Foreign Data Wrappers
  • Database Security
  • Upgrading Best Practices
As mandatory pre-requisites, people considering taking the Professional Certification exam must:
  • Complete the Advanced PostgreSQL Administration training course offered by EnterpriseDB. This course presents the minimum knowledge of concepts and skills required to achieve this certification
  • Clear the PostgreSQL Associate Certification Exam

Exam Details:
Test Location: On-line
Format: Multiple choice
Length: 1 hour
Access Period: Take anytime within 6 calendar weeks of your purchase.
Prerequisites: 
Course: Advanced PostgreSQL Administration
Associate Level Certification: PostgreSQL 10 Associate Certification  










출처
https://www.enterprisedb.com/ko/training/postgres-certification
https://www.enterprisedb.com/ko/free-postgres-training
https://www.enterprisedb.com/ko/training/learning-paths
https://www.enterprisedb.com/ko/training/certification-faq





자격증 PostgreSQL Associate Certification 10


EnterpriseDB 에서 발급하는




PostgreSQL 10 Associate Certification

This certification exam assesses and certifies that a database professional can demonstrate the fundamental skills necessary to maintain and manage a PostgreSQL server and related applications in a production environment.

The PostgreSQL Associate Certification requires competence in the following:

  • PostgreSQL Database Server Architecture
  • Installation
  • Configuration
  • Creating and Managing Databases
  • User Interfaces: PSQL and pgAdmin4
  • Database Clusters
  • Security
  • SQL Queries and Data Handling
  • Backup and Recovery
  • Point-in Time Recovery
  • Routine Maintenance Tasks
  • Postgres Data Dictionary
  • Moving Data
Students considering taking the Associate Certification exam are strongly encouraged to complete the associated EnterpriseDB training course on Foundations of Postgres Administration. This class presents the minimum knowledge of concepts and skills required to achieve this certification. Equivalent hands-on experience is acceptable to meet the exam prerequisite, however formal training is recommended for maximum success.

Exam Details:
Test Location: On-line
Format: Multiple choice
Length: 1 hour
Access Period: Take anytime within 6 calendar weeks of your purchase.
Recommended Prerequisites: 
 Course: Foundations of Postgres Administration 
Badge:
  EDB Certified Associate - PostgreSQL 10








출처
https://www.enterprisedb.com/ko/training/postgres-certification
https://www.enterprisedb.com/ko/free-postgres-training
https://www.enterprisedb.com/ko/training/learning-paths
https://www.enterprisedb.com/ko/training/certification-faq

2019년 10월 10일 목요일

PostgreSQL psql 에서 more 없이 결과 출력 방법

PostgreSQL psql 에서 쿼리의 결과 내용이 많으면,
한번에 한 화면에 나오지 않는다.

한 화면 만큼 결과가 나오고 나면 "--More--" 메세지가 나오고,
key 입력을 해야 그 다음 결과가 출력된다.

아래처럼 입력을 하면 key 입력을 하는 불편함을 없앨 수 있다.
\pset pager off

필요할 경우 다시 나타나게 할 수 있다.
\pset pager on

on, off 없이 toggle 형태로 입력 할 수 있다.
\pset pager



출처
https://stackoverflow.com/questions/11180179/postgresql-disable-more-output

WinSCP 기부

나는 리눅스(Linux)를 많이 사용하는 편이다. 회사에서도 사용하고, 개인적으로도 사용하고 있다. 그러다 보니 자연스럽게, SFTP를 많이 사용하게 된다. 리눅스에서는 SFTP에 대해 기본적으로 이렇게 저렇게 잘 지원을 해주는 편인데, 윈도...