Search For:
- Home
- Search For:
psql to restore a text dump How to do it
This article will guide you on steps to perform text dump restoration. Basically, psql restores a text dump in the same file format.
You can backup a single table, a #schema, or a complete database. Select the name of the backup source in the #pgAdmin tree control, right click to open the context menu, and select Backup… to open the #Backup dialog.
The name of the object selected will appear in the dialog title bar.
In #PostgreSQL, you can restore a database in two ways:
i. Using psql to restore plain #SQL script file generated by pg_dump and pg_dumpall tools.
ii. Using pg_restore to restore tar file and directory format created by the pg_dump tool.
To Restore Postgres Database:
1. Restore a postgres database. $ psql -U erp -d erp_devel -f mydb.sql.
2. Backup a local postgres database and restore to remote server using single command: $ pg_dump dbname | psql -h hostname dbname.
3. Restore all the postgres databases.
4. Restore a single postgres table.
How to set rDNS in Windows Name Servers
This article will guide you on how to set #rDNS records in Windows Name servers. rDNS means mapping the address to a #hostname.
Nslookup is an MS-DOS utility that enables a user to look up the IP address of a domain or host on a network. The #nslookup command can also perform a reverse lookup using an IP address to find the domain or host associated with that IP address.
PTR record ( a pointer record ) is the certain type of DNS record that resolves an IP address to a host name. Getting reverse #DNS going is done by finding the PTR records in use by a DNS server. These PTR records will be managed by the company that is in control of the IP address which was assigned to you.
1. A pointer (PTR) record is a type of Domain Name System (DNS) record that resolves an IP address to a domain or host name, unlike an A record which points a domain name to an IP address.
2. PTR records are used for the reverse DNS lookup. Using the IP address, you can get the associated domain or host name.
3. An A record should exist for every PTR record.
4. The usage of a reverse DNS setup for a mail server is a good solution.
5. While in the domain DNS zone the hostname is pointed to an IP address, using the reverse zone allows to point an IP address to a hostname.
git fetch failed with exit code 1
This article will guide you on how to get rid of Git fetch error and also the causes of this error. To fix git fetch failed with exit code 1 error, simply add an explicit --force, checking for syntax error, and verifying the configuration file for its properness in case sensitivity.
Plesk MSSQL remote connection
This article will guide you on how to enable and resolve #MSSQL related #errors. MSSQL remote connection is disabled in #Plesk servers by default.
To enable remote connections to MS SQL server:
1. Connect to the server via RDP.
2. Press the Start button, go to Microsoft SQL Server XXXX (where XXXX is the MSSQL version) and click the SQL Server XXX Configuration Manager.
3. Open the SQL Server Configuration Manager (Local) > #SQL Server Network Configuration menu and click the Protocols for MSSQLSERVERXXXX (where XXXX is the MSSQL version).
4. Make sure that the TCP/IP protocol has the Enabled status
5. Double-click the TCP/IP protocol, go to the IP Addresses tab and scroll down to the IPAll section.
6. Specify 1433 in the TCP Port field (or another port if 1433 is used by another MS SQL Server) and press the OK button:
Note: the specified port, e.g, 1433, must be opened in the firewall.
Add special character domain names in cPanel
This article will guide you on how to add special character to #domain #names in #cPanel. A domain name can be up to 63 #characters (letters, numbers or combination) long plus the 4 characters used to identify the domain extension (.com, . net, . org). The only symbol character domain names can include is a hyphen (-) although the domain name cannot start or end with a hyphen nor have consecutive hyphens.
Domain names can only use letters, numbers, the fada character (acute accent) and hyphens (“-“). Spaces and other symbols are not permitted for use. Names cannot begin or end with a hyphen and are not case sensitive.
To customize my domain name:
1. Log in to your Domain.com, hosting account.
2. Go to the Domain Control Panel settings.
3. Click on the Website Builder Icon.
4. Right next to the Domain name you wish to change, click on Options.
5. A menu will drop down, click on Change Domain.
More about Engintron cPanel
This article will guide you on how to #install #Engintron in #cPanel & fix relating #errors. Engintron is a third-party plugin to integrate Nginx on cPanel servers.
Engintron integrates Nginx into cPanel so you can enjoy amazing performance for your sites, without having to sacrifice important hosting features found in cPanel.
Engintron is totally free to use!
The way Engintron sets up Nginx inside your cPanel is a lot like how the popular #CloudFlare CDN works. Nginx (like CloudFlare) directly serves all static content like CSS, JS, images etc. instead of your actual web server, thus lowering the load on your cPanel server.
Engintron is the easiest way to integrate Nginx to your cPanel server:
1. Installation process is not very complicated for Engintron.
2. Also, installation and updates are very fast, they take only a few seconds.
3. Engintron is using the official repositories for Nginx, all Engintron software is updated whenever cPanel is updated. If something has changed on Engintron and you need to re-install it, you can install it on top of the previous installation. You don't need to uninstall it first like other Nginx installer plugins for cPanel. It works from CentOS 5 up to CentOS 7. Engintron has an app dashboard inside WHM.
4. The interface has basic controls for Nginx, Apache, MySQL. These controls allow you to edit various configuration files. Inside the Engintron app dashboard you’ll also find some utilities to monitor things like Nginx access & error logs, check processes on your server or see incoming traffic on port 80. It doesn’t require Nginx or Apache host synchronization when adding new domains via cPanel.
5. Also, Engintron is released under the GNU/GPL license and is 100% open source.
