Lukas Fittl lfittl
lfittl
/ master archive command
Created
May 19, 2009 22:52
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /usr/bin/walmgr /etc/walmgr/master.ini xarchive %p %f >> /var/log/postgresql/archivecmd.log |
lfittl
/ gist:132247
Created
June 18, 2009 22:25
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| app@core:/soup/shared/git_cache/vendor$ git clone git@github.com:soup/rails.git rails | |
| Initialized empty Git repository in /soup/shared/git_cache/vendor/rails/.git/ | |
| error: refs/heads/1-2-stable does not point to a valid object! | |
| error: refs/heads/2-0-stable does not point to a valid object! | |
| error: refs/heads/2-1-stable does not point to a valid object! | |
| error: refs/heads/2-2-stable does not point to a valid object! | |
| error: refs/heads/3-0-unstable does not point to a valid object! | |
| error: refs/heads/active_model does not point to a valid object! | |
| error: refs/heads/master does not point to a valid object! | |
| error: refs/heads/path_refactor does not point to a valid object! |
lfittl
/ gist:132390
Created
June 19, 2009 03:38
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| lfittl@capricorn:~/Documents/soup/vendor/rails%> git push --tags | |
| error: refs/heads/1-2-stable does not point to a valid object! | |
| error: refs/heads/2-0-stable does not point to a valid object! | |
| error: refs/heads/2-1-stable does not point to a valid object! | |
| error: refs/heads/2-2-stable does not point to a valid object! | |
| error: refs/heads/3-0-unstable does not point to a valid object! | |
| error: refs/heads/active_model does not point to a valid object! | |
| error: refs/heads/master does not point to a valid object! | |
| error: refs/heads/path_refactor does not point to a valid object! | |
| error: refs/heads/wip_abstract_controller does not point to a valid object! |
lfittl
/ gist:132401
Created
June 19, 2009 03:53
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| lfittl@capricorn:~/Documents%> git clone git@github.com:soup/rails.git rails | |
| Initialized empty Git repository in /Users/lfittl/Documents/rails/.git/ | |
| error: refs/heads/1-2-stable does not point to a valid object! | |
| error: refs/heads/2-0-stable does not point to a valid object! | |
| error: refs/heads/2-1-stable does not point to a valid object! | |
| error: refs/heads/2-2-stable does not point to a valid object! | |
| error: refs/heads/3-0-unstable does not point to a valid object! | |
| error: refs/heads/active_model does not point to a valid object! | |
| error: refs/heads/master does not point to a valid object! | |
| error: refs/heads/path_refactor does not point to a valid object! |
lfittl
/ gist:132404
Created
June 19, 2009 03:55
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| lfittl@capricorn:~/Documents/soup/vendor/rails%> git push | |
| error: refs/heads/1-2-stable does not point to a valid object! | |
| error: refs/heads/2-0-stable does not point to a valid object! | |
| error: refs/heads/2-1-stable does not point to a valid object! | |
| error: refs/heads/2-2-stable does not point to a valid object! | |
| error: refs/heads/3-0-unstable does not point to a valid object! | |
| error: refs/heads/active_model does not point to a valid object! | |
| error: refs/heads/master does not point to a valid object! | |
| error: refs/heads/path_refactor does not point to a valid object! | |
| error: refs/heads/wip_abstract_controller does not point to a valid object! |
lfittl
/ gist:133435
Created
June 21, 2009 07:09
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| lfittl@capricorn:~/Documents%> git clone git@github.com:soup/rails.git rails | |
| Initialized empty Git repository in /Users/lfittl/Documents/rails/.git/ | |
| error: refs/heads/wip_abstract_controller does not point to a valid object! | |
| error: refs/heads/wip_abstract_controller does not point to a valid object! | |
| remote: Counting objects: 100011, done. | |
| remote: Compressing objects: 100% (22104/22104), done. | |
| remote: Total 100011 (delta 77209), reused 99409 (delta 76728) | |
| Receiving objects: 100% (100011/100011), 17.86 MiB | 129 KiB/s, done. | |
| Resolving deltas: 100% (77209/77209), done. | |
| warning: remote HEAD refers to nonexistent ref, unable to checkout. |
lfittl
/ gist:170394
Created
August 19, 2009 15:01
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| relname | size | refrelname | relfilenode | relkind | reltuples | relpages | |
| ----------------------------------------------------+------------+-------------------------+-------------+---------+-----------+---------- | |
| attributes | 13 GB | pg_toast_168091 | 168091 | r | 46825528 | 1741245 | |
| index_indexed_attributes_on_data | 6135 MB | | 319836 | i | 40098128 | 785236 | |
| indexed_attributes | 5281 MB | pg_toast_168211 | 168211 | r | 40098128 | 675916 | |
| posts | 2552 MB | | 168177 | r | 23600586 | 326697 | |
| index_attributes_on_post_id_and_type | 2518 MB | | 319833 | i | 46825528 | 322290 | |
| stats_associated_records | 21 |
lfittl
/ gist:176267
Created
August 27, 2009 12:51
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| key | buffers | dirty_buffers | percentage_of_shared_buffers | |
| --------------------------------------+---------+---------------+------------------------------ | |
| posts | 148067 | 111 | 37.6554 | |
| posts_pkey1 | 34057 | 57 | 8.6611 | |
| attributes | 33867 | 222 | 8.6128 | |
| feeds | 33613 | 1882 | 8.5482 | |
| index_attributes_on_post_id_and_type | 27435 | 13 | 6.9771 | |
| posts_feed_id | 13132 | 120 | 3.3396 | |
| assets | 11147 | 38 | 2.8348 | |
| notifications | 10365 | 8 | 2.6360 |
lfittl
/ gist:177265
Created
August 28, 2009 21:29
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Aug 28 20:00:29 192.168.96.40 postgres-master[30672]: [3-1] 2009-08-28 20:00:29 UTC LOG: automatic vacuum of table "soup_production.public.feeds": index scans: 1 | |
| Aug 28 20:00:29 192.168.96.40 postgres-master[30672]: [3-2] pages: 0 removed, 132742 remain | |
| Aug 28 20:00:29 192.168.96.40 postgres-master[30672]: [3-3] tuples: 701 removed, 64714 remain | |
| Aug 28 20:00:29 192.168.96.40 postgres-master[30672]: [3-4] system usage: CPU 0.76s/0.42u sec elapsed 456.48 sec | |
| Aug 28 20:00:29 192.168.96.40 postgres-master[30672]: [4-1] 2009-08-28 20:00:29 UTC LOG: automatic vacuum of table "soup_production.pg_toast.pg_toast_168147": index scans: 0 | |
| Aug 28 20:00:29 192.168.96.40 postgres-master[30672]: [4-2] pages: 0 removed, 0 remain | |
| Aug 28 20:00:29 192.168.96.40 postgres-master[30672]: [4-3] tuples: 0 removed, 0 remain | |
| Aug 28 20:00:29 192.168.96.40 postgres-master[30672]: [4-4] system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |
| Aug 28 20:01:38 192.168.96.40 postgres-master[30672]: [5-1] 2009-08-28 20:01: |
lfittl
/ gist:177281
Created
August 28, 2009 21:39
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Table "public.feeds" | |
| Column | Type | Modifiers | |
| -------------------------+--------------------------+---------------------------------------------------- | |
| id | bigint | not null default nextval('feeds_id_seq'::regclass) | |
| url | character varying(2048) | default NULL::character varying | |
| name | character varying(255) | default NULL::character varying | |
| imported_at | timestamp with time zone | | |
| blog_id | bigint | | |
| humane_url | character varying(2048) | default NULL::character varying | |
| type | character varying(255) | default NULL::character varying |
OlderNewer