Posts

Twitter account

I've set up the  twitter account , so you can follow me. I don't have much time to post full blog messages here, but there are many issues and thoughts which I can share via Twitter. And anyway Twitter is a good networking, communication and news tool, so everybody can gain benefits from it. Stay in touch!

Mini HOWTO: Upgrade PostgreSQL database in Fedora

The main problem in upgrading PostgreSQL databases is downgrading to previous version of the RDBMS, especially if you accidentally updates the software but forget to make the database dump. I have faced the same problem and find it's not so easy task. So let me show my solution for this: The problem: after OS upgrade I have PostgreSQL 8.4, and can't start it because the database format is incompatible and suited for PSQL 8.3 only. Install required YUM-configuration for the version of PosgreSQL you want to install, for my case PostgreSQL 8.3. There is an excellent http://yum.pgrpms.org/ website, which provides required rpms: $ sudo rpm -ivh http://yum.pgsqlrpms.org/reporpms/8.3/pgdg-fedora-8.3-7.noarch.rpm Remove the current PostgreSQL installation. It requires few steps (there is no easy way to delete postgresql-libs because there are too many dependencies): Get the list of postgresql packages: $ rpm -qa | grep postgresql postgresql-server-8.4.3-1.fc12.i686 postgresql-...

Using Python command line

Recently I had a task to write a command file for Windows that run a simple Python commands via python –c command . The manual says that command may contain multiple statements separated by newlines. Unfortunately, Windows console doesn’t allow it (and Ctrl-T trick doesn’t help) so I had to find a workaround. The intuition and language reference helped me to find out that the simple statements can be separated by semicolons like in C/C++ (however, these languages allow to separate all the commands, not the only simple ones). Let me give an example. Imagine that accidentally I want to know the error message corresponding to the error code 9. Of course, I can read manuals and documentation, but there is a more simple way: $ python -c "import os;print os.strerror(9)" Bad file descriptor But this "trick" works only with simple statements. It is not allowed to mix simple and compound statements, so the following command will not work: python -c "import os;...

IELTS Results

My results: Listening: 7.5 Reading: 7.5 Writing: 6.5 Speaking: 6.5 Overall Band Score: 7.0 My wife's results: Listening: 7.0 Reading: 7.0 Writing: 6.5 Speaking: 8.5 Overall Band Score: 7.5 Results are acceptable in despite of the problems with the equipment during the exam, and that it was boring and tedious, especially writing section.

Trac Ticket Workflow

Trac is the wiki and issue tracking system that is the most used for my software development projects. Let me share few hints about its ticket workflow, especially about the statuses, the roles of the participants, and let me give an example of the workflow config. But if you are interested in other things like Trac plugins, source browser, customizing, etc, let me know. All the information given below regards the workflow described at the end of the article. The original Trac workflow is missed vital features like the support for ticket verifying, or the required ticket statuses range, so I do not use it in my projects. The description of the main statuses: new - the ticket has been created; in-progress - the developer has began to work with the ticket; fixed - the ticket is fixed (the problem issued in the ticket is solved); verified - the ticket is verified (tester or PM has verified that the ticket is fixed correctly); closed - the ticket is closed (it's not...

Curriculum Vitae

Alexander Slesarev Calgary, AB | XXX-XXX-XXXX | alex.slesarev@gmail.com | https://nuald.blogspot.com Software Engineering Technical Leader - Cisco Meraki | 2021 - present Assisting in deployment and optimization of Secure Threat Services ecosystem (Snort, Talos Intelligence integration, Click, C/C++, Lua, Go, Python, Ruby, Redis). Extend and redesign MX Security Features (AMP, STS) to work in IPv6 and mixed IPv4/IPv6 networks (Click, C/C++). Extend and redesign MX Security Features (STS, NBAR) to efficiently work on high-end MX appliances having multi-core Click (lockfree algorithms, Click, C/C++, Lua, Go, Rust). Upskilling the company employees and new hires on MX Security Features, Click configuration, cryptography (including FIPS and PCI certification) and performance optimizations. Lead Software Development Engineer - NuData Security/Mastercard | 2014 - 2021 Designed and created a codegenerator for the shared classes and enumerations (Go, Java, Ja...

Moving to Canada

I'm going to immigrate to Canada, and the first step is complete – I have received a reference number from the FSW Centralized Intake Office. I had applied as Computer and Information Systems Manager due to my job position now (Project Manager) which I hold more than 5 years. The next challenge is an IELTS exam that I have to pass in the next few weeks.