postgress

SELECT count(*) FROM pg_stat_activity;   SELECT usesysid, usename,state FROM pg_stat_activity;    

quotes

“Linux used ideas from MINIX MINIX used ideas from UNIX UNIX used ideas from MULTICS MULTICS used ideas from CTSS CTSS used ideas from FMS” quote: Andrew S. Tanenbaum

Libros

The Art of Digital Design: Introduction to Top-down Design (Inglés)  – 1 oct 1986 de David E. Winkel (Autor), Franklin P. Prosser (Autor) Chapter 7 Designing a Minicomputer   Computer Architecture and Organization 3rd International Edition by John P. Hayes (Author) Publisher: McGraw Hill Higher Education; 3rd International edition (June 1, 1998) Language: English ISBN-10:… Leer más »

Routing between vlans – Router on a Stick and Switching L3 routing

  S1#conf t S1(config)#vlan 51 S1(config-vlan)#name ENG S1(config-vlan)#vlan 52 S1(config-vlan)#name MGMT S1(config)#int gi0/0 S1(config-if)#switchport mode access S1(config-if)#switchport access vlan 51 S1(config-if)#spanning-tree portfast S1(config)#int gi0/1 S1(config-if)#switchport mode access S1(config-if)#switchport access vlan 52 S1(config-if)#spanning-tree portfast   S1#show vlan VLAN Name Status Ports —- ——————————– ——— ——————————- 1 default active Gi0/2, Gi0/3, Gi1/0, Gi1/1 Gi1/2, Gi1/3 51 ENG… Leer más »

Routing Lab —Static route

    R1#show controller S0/0 Interface Serial0/0 Hardware is GT96K DCE 530, clock rate 2000000 idb at 0x653ED468, driver data structure at 0x653F4B8C wic_info 0x653F5190 Physical Port 1, SCC Num 1 R1#sh ip int brief Interface IP-Address OK? Method Status Protocol FastEthernet0/0 unassigned YES unset administratively down down Serial0/0 unassigned YES unset administratively down down… Leer más »

Troubleshooting Switches

S1#show ip int brief S1#show interfaces status Port Name Status Vlan Duplex Speed Type Gi0/0 connected 5 auto auto unknown Gi0/1 connected 2 auto auto unknown Gi0/2 connected 1 auto auto unknown Gi0/3 connected 1 auto auto unknown Gi1/0 connected 1 auto auto unknown Gi1/1 connected 1 auto auto unknown Gi1/2 connected 1 auto auto… Leer más »

VLAN routing

Create vlans SW1#conf t SW1(config)#vlan 2 SW1(config-vlan)#name ACCT SW1(config-vlan)#exit SW1(config)#vlan 3 SW1(config-vlan)#name Sales SW1(config-vlan)#exit SW1(config)#int gigabitEthernet 0/0 SW1(config-if)#switchport access vlan 200 TRUNK PORTS Manual Configuration ( TRUNK / NONEGOTITATE) Dynamic Configuration ( Dinamic Auto / Dynamic Desirable) Dynamic Configuration DTP (Dynamic Trunking Protocol) * * SW1 Desirable -> Los dos se convierten en Trunks (Envian… Leer más »

Cisco commands

41 iperf-3 https://iperf.fr/ iPerf – The ultimate speed test tool for TCP, UDP and SCTP Server: iperf3 -s Client:   iperf3 -c 192.168.1.1 TinyCore #!/bin/sh # Variable Assignment INTERFACE=eth0 ADDRESS=192.168.0.100 BROADCAST=192.168.0.255 GATEWAY=192.168.0.1 NETMASK=255.255.255.0 NAMESERVER1=8.8.8.8 NAMESERVER2=8.8.4.4 # Bring up the interface ifconfig $INTERFACE $ADDRESS netmask $NETMASK broadcast $BROADCAST up route add default gw $GATEWAY $INTERFACE #… Leer más »