--- title: Installing pg_timetable as a service in Linux | daily.dev description: Step-by-step guide for installing and configuring pg_timetable as a Linux systemd service, as a replacement for the deprecated pgAgent. Covers creating a... canonical: https://daily.dev/posts/installing-pg-timetable-as-a-service-in-linux-ckcq7npvj twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Installing pg_timetable as a service in Linux | daily.dev og:description: Step-by-step guide for installing and configuring pg_timetable as a Linux systemd service, as a replacement for the deprecated pgAgent. Covers creating a... og:url: https://daily.dev/posts/installing-pg-timetable-as-a-service-in-linux-ckcq7npvj og:image: https://api.daily.dev/og/posts/CKcq7nPvj.png og:image:alt: Installing pg_timetable as a service in Linux og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Installing pg_timetable as a service in Linux **[Planet PostgreSQL](https://daily.dev/sources/planet-postgresql)** · 5 min read · 0 upvotes · 0 comments ## Summary Step-by-step guide for installing and configuring pg_timetable as a Linux systemd service, as a replacement for the deprecated pgAgent. Covers creating a dedicated system account and PostgreSQL role, downloading the correct binary for your architecture, setting up config and log directories, writing a systemd service unit file, and enabling the service. Also mentions a migration SQL script for copying existing pgAgent jobs to pg_timetable, and notes that schema creation happens automatically on first agent startup. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [Replacing pgAgent with pg\_timetable: Part 1](https://daily.dev/posts/replacing-pgagent-with-pg-timetable-part-1-keuxzepf3) · Planet PostgreSQL · 5 upvotes · 1 comments - [How To Install and Use PostgreSQL on Ubuntu 16.04](https://daily.dev/posts/how-to-install-and-use-postgresql-on-ubuntu-16-04-depni7xv8) · DigitalOcean Community · 0 upvotes · 0 comments - [You Don't Love systemd Timers Enough](https://daily.dev/posts/you-don-t-love-systemd-timers-enough-x0ogcxoqr) · Lobsters · 1 upvotes · 0 comments - [Postgres Monitoring for SQL Server DBAs: Statistics and Logs 101](https://daily.dev/posts/postgres-monitoring-for-sql-server-dbas-statistics-and-logs-101-am6ptsgaz) · pganalyze · 2 upvotes · 0 comments --- Tags: [#linux](https://daily.dev/tags/linux), [#postgresql](https://daily.dev/tags/postgresql) [View this post on daily.dev](https://daily.dev/posts/installing-pg-timetable-as-a-service-in-linux-ckcq7npvj) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Installing pg_timetable as a service in Linux","url":"https://daily.dev/posts/installing-pg-timetable-as-a-service-in-linux-ckcq7npvj","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/installing-pg-timetable-as-a-service-in-linux-ckcq7npvj"},"datePublished":"2026-07-14T20:49:23.584Z","dateModified":"2026-07-14T20:56:20.124Z","description":"Step-by-step guide for installing and configuring pg_timetable as a Linux systemd service, as a replacement for the deprecated pgAgent. Covers creating a...","image":"https://media.daily.dev/image/upload/s--58gMhC4P--/f_auto/v1722860399/public/Placeholder%2012","thumbnailUrl":"https://media.daily.dev/image/upload/s--58gMhC4P--/f_auto/v1722860399/public/Placeholder%2012","isAccessibleForFree":true,"articleSection":"Planet PostgreSQL","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Planet PostgreSQL","logo":"https://media.daily.dev/image/upload/logos/placeholder.jpg","url":"https://daily.dev/sources/planet-postgresql"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/installing-pg-timetable-as-a-service-in-linux-ckcq7npvj","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"linux,postgresql","timeRequired":"PT5M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Planet PostgreSQL","item":"https://daily.dev/sources/planet-postgresql"},{"@type":"ListItem","position":3,"name":"Installing pg_timetable as a service in Linux"}]} ```