gurjeet

edb=# select now() as "time", now()::timestamptz(0) as "time_round", date_trunc('seconds', now()) as "time_trunc";
               time               |        time_round         |        time_trunc         
----------------------------------+---------------------------+---------------------------
 21-MAY-14 14:19:04.549852 -04:00 | 21-MAY-14 14:19:05 -04:00 | 21-MAY-14 14:19:04 -04:00
(1 row)

gurjeet

create table public.traffic_analysis(date_text text, load_avg_1_min double precision, hostname text not null, ts timestamp);

create type public.weekdays as enum (
'Sunday',
'Monday',
'Tuesday',
'Wednesday',
'Thursday',
'Friday',
'Saturday'

gurjeet

/* Item names */
create table item (i_id int, i_name text);

/* Stock counts of items */
create table stock (s_i_id int, s_quantity int);

/* All rows here represent one order; each row is its line items */
create table order_line (ol_i_id int, ol_quantity int);

insert into item values(1, 'item 1');

gurjeet

postgres=# select '6 days 23:45:00'::interval - '6 days 23:23:00'::interval;
 ?column?
----------
 00:22:00
(1 row)

postgres=# select '00:46:00'::interval - '00:24:00'::interval;
 ?column?
----------
 00:22:00

gurjeet

[bart] #global section

backup_path = /path/to/backup/dir

pg_basebackup_path = /path/to/pg_basebackup

log_file= /path/to/logfile

[Server1] # name the server being configured.

gurjeet

We are facing a problem in dropping a tablespace after crash recovery. The
recovery starts from the last checkpoint, but the tables that were created by
a transaction in a tablespace before the checkpoint are still lying around; the
transaction had not finished by the time of crash.

After recovery, when the app tries to drop the tablespace, the command fails
since the tablespace directory is not empty.

Solving this problem has become quite critical since the the platform where
Postgres is being used is supposed to run unattended for a few years. The

gurjeet

This proposal strikes me as something mysql would do, not the standards committee.
- Tom Lane responding to an interpretation of SQL:2011.

DBAs hate getting eaten by crocodiles.
- Robert Haas.

Get on the stick, Cupertino ... everybody else had this fixed six months ago.
- Tom Lane; prompting Apple to fix their OpenSSL libraries.

gurjeet

sfdisk delete a partition https://laas.mine.nu/uclibc/util-linux-ng-2.14.2/fdisk/sfdisk.examples

http://www.rodsbooks.com/missing-parts/index.html


http://www.dedoimedo.com/computers/linux-uninstall.html

gurjeet

var http = require('http');
var url = 'http://radio.pedromtavares.com:10000'; // URL to a known Icecast stream


var icecast = require('icecast-stack');
var stream = icecast.createReadStream(url);

// var radio = require("radio-stream");
// var stream = radio.createReadStream(url);

gurjeet

Administrator@AMAZONA-AK1BTP3 ~
$ diff -c -r del/build-farm-4.9/ bf/
diff -c -r del/build-farm-4.9//build-farm.conf bf//build-farm.conf
*** del/build-farm-4.9//build-farm.conf Mon Nov 12 09:47:55 2012
--- bf//build-farm.conf Thu Jan  3 20:51:07 2013
***************
*** 35,41 ****
      tar_log_cmd => undef, # default is "tar -z -cf runlogs.tgz *.log"
      # replacement must have the same effect
      # must be absolute, can be either Unix or Windows style for MSVC