https://wiki.tbruce.com/ 2026-06-18T06:21:07+00:00 https://wiki.tbruce.com/ https://wiki.tbruce.com/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2025-10-23T01:18:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.tbruce.com/doku.php?id=database:archive&rev=1761182323&do=diff Archive See also: Postgresql | Shell Archive Script: postgres@kb0odu:~/bin$ cat archive_sync.ksh #!/usr/bin/ksh WAL_PATH=$1 # %p WAL_FILE=$2 # %f ARCHIVE_DIR="/var/lib/postgresql/archived_logs" if [ ! -d "${ARCHIVE_DIR}" ] ; then echo $0 " Archive directory ${ARCHIVE_DIR} does not exist" >&2 exit 1 fi echo "ARCHIVE_DIR is: $ARCHIVE_DIR" >> /tmp/postgres_archive.txt echo "WAL_PATH (%p / Param 1) is: $WAL_PATH" >> /tmp/postgres_archive.txt echo "WAL_FILE (%f / Param 2) … text/html 2020-09-15T15:45:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.tbruce.com/doku.php?id=database:database&rev=1600184756&do=diff See also Main Index Database Information db2 Microsoft SQL Server (MSSQL) mysql postgresql Sqlite Sybase text/html 2024-03-06T21:51:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.tbruce.com/doku.php?id=database:db2&rev=1709761895&do=diff See also database, Index This is from a blog post on 2006/08/12 13:54 Some tags for this included: db2, ibm, sql, manual, draft A list of IBM DB2 manuals I have. I am no longer able to upload them (probably a Dokuwiki configuration I still need to make or that regressed). In any case, I can find them in my database volume (dl_database/DB2/v7.x directory). text/html 2020-09-15T15:45:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.tbruce.com/doku.php?id=database:drupal_queries&rev=1600184757&do=diff Drupal Queries See also: Postgresql Original Date Written: 2008/08/15 20:43 Description: Some Drupal Queries View node information SELECT nid, title, to_timestamp(created) as "created", to_timestamp(changed) as changed FROM node ORDER BY nid }}} text/html 2025-10-23T00:47:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.tbruce.com/doku.php?id=database:less&rev=1761180444&do=diff less See also Postgresql, Linux Software Articles Raw Control Characters In Less pager Less is my default terminal pager program. On GNU Debian Linux pager is just a symbolic link to your less or one of other available pager progams like more , most , lv etc..( run text/html 2021-03-20T08:31:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.tbruce.com/doku.php?id=database:migrate_mysql_to_postgres&rev=1616229064&do=diff See also Database, MySQL, Postgresql Migrate MySQL to Postgres Just a little bit of sample code. ~/devel2/mysql2pgsql$ ./my2pg.py --mysql-user=timb --mysql-password=timb_password --pg-user=drupal --pg-password=drupal_password pc015 tbruce57 pc015 tbruce $ psql -h pc015 -U timb -W tbruce $ ./my2pg.py --mysql-user=timb --mysql-password=timb_passworrd --pg-user=pg_user --pg-password=pg_password pc015 horoscope pc015 horoscope text/html 2020-09-15T15:45:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.tbruce.com/doku.php?id=database:mysql&rev=1600184757&do=diff See also database, Main Index MySQL MySQL is a database engine. It is owned by Oracle, now, but was previously an independent company called MySQL AB. migrate_mysql_to_postgres mysql_info text/html 2020-09-15T15:45:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.tbruce.com/doku.php?id=database:mysql_info&rev=1600184757&do=diff See also Database, MySQL, Postgresql MySQL Info Original date: 2006/04/13 23:54 tags: mysql, sql, database, draft Description: Some info about MySQL that I wanted to keep track of. MySQL is a free database available from My SQL AB (www.mysql.com) (then Sun and now Oracle). This database is a fully relational database environment and there are several tools available to help you manage the database. text/html 2025-10-23T16:45:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.tbruce.com/doku.php?id=database:postgresql&rev=1761237911&do=diff Postgresql See also Database, Index See also postgres_stack_traces - Info on conducting a stack trace. Databases breaking_horoscopes Horoscope mail migrate_mysql_to_postgres drupal_queries Postgres Configuration Postgres Stack Traces psql See also less about configuring less (and more?) as your pager. Other Notes Archive Info and script for testing for Pure Storage and Gluster. text/html 2024-10-03T04:13:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.tbruce.com/doku.php?id=database:postgres_stack_traces&rev=1727928792&do=diff Postgres Stack Traces See also Database Engines, postgresql Reference Matt Smiley's email Dated: 23 Jan 2013 Attached are annotated examples of: * how to capture stack traces using the helper script * a few tips on finding useful facts in the stack traces How to Capture __________