Search Results for: how

How to Create a New Table in PostgreSQL

You can create a new table by specifying the table name, along with all column names and their types: CREATE TABLE weather ( city varchar(80), temp_lo int, — low temperature temp_hi int, — high temperature prcp real, — precipitation date date ); You can enter this into psql with the line breaks. psql will recognize that the(…)

How to Access a Database in PostgreSQL

Once you have created a database, you can access it by: Running the PostgreSQL interactive terminal program, called psql, which allows you to interactively enter, edit, and execute SQL commands. Using an existing graphical frontend tool like pgAdmin or an office suite with ODBC or JDBC support to create and manipulate a database. These possibilities are not covered in this tutorial. Writing a(…)

How To create a new database in PostgreSQL

The first test to see whether you can access the database server is to try to create a database. A running PostgreSQL server can manage many databases. Typically, a separate database is used for each project or for each user. Possibly, your site administrator has already created a database for your use. He should have told you(…)

Solr indexing – Master/Slave replication, how to handle huge index and high traffic

- Does Solr have some limitation in size for its index? – Is there any max size when replicating segments from master to slave? Post By Gishore J Kallarackal (2,121 Posts)Gishore J Kallarackal is the founder of techgurulive. The purpose of this site is to share information about free resources that techies can use for(…)

How to Create and Configure Virtual Directories in IIS 7.0

By using IIS Manager, you can create a virtual directory for an ASP.NET Web application that is hosted in IIS 7.0. A virtual directory appears to client browsers as if it is in the Web server’s root directory, even though it can physically reside somewhere else. This approach enables you to publish Web content that(…)

How to Create and Configure Virtual Directories in IIS 5.0 and 6.0

You can use IIS Manager to create a virtual directory for an ASP.NET Web application that is hosted in IIS 5.0, IIS 5.1, and IIS 6.0. A virtual directory appears to browsers as if it were contained in a Web server’s root directory, even though it can physically reside somewhere else. This approach enables you to publish Web content that(…)

How to List processes by % cpu usage – Linux Commands

Please refer the following command to get  processes by % cpu usage  under Linux or Unix System #ps -e -o pcpu,cpu,nice,state,cputime,args –sort pcpu | sed ‘/^ 0.0 /d’ [root@pwas2 ~]# ps -e -o pcpu,cpu,nice,state,cputime,args –sort pcpu | sed ‘/^  0.0 /d’ %CPU CPU  NI S     TIME COMMAND 2.7   –   0 S 00:00:03(…)

How to Show network traffic on port 80 – Linux Commands

Please refer the following command to get   network traffic on port 80 under Linux or Unix System # tcpdump not port 80 Post By Gishore J Kallarackal (2,121 Posts)Gishore J Kallarackal is the founder of techgurulive. The purpose of this site is to share information about free resources that techies can use for reference. You(…)

How to Show top disk users in current dir – Linux Commands

Please refer the following command to get top disk users in current dir   under Linux or Unix System # du -s * | sort -k1,1rn | head Post By Gishore J Kallarackal (2,121 Posts)Gishore J Kallarackal is the founder of techgurulive. The purpose of this site is to share information about free resources that techies(…)

How to Show files by size, biggest last- Linux Commands

Please refer the following command to get  files by size, biggest last  under Linux or Unix System # ls -lSr Example.. [root@pwas2 ~]# ls -lSr total 196212 -rw-r–r– 1 root root 0 Feb 5 2010 test1.txt -rw-r–r– 1 root root 1124 Jul 8 2008 gish -rw-r–r– 1 root root 1574 Jan 24 2008 anaconda-ks.cfg -rw-r–r– 1(…)