diff --git a/manifests/devel/postgres.pp b/manifests/devel/postgres.pp
index dcc423c..a799643 100644
--- a/manifests/devel/postgres.pp
+++ b/manifests/devel/postgres.pp
@@ -1,7 +1,12 @@
 class profile::devel::postgres {
   $packages = hiera_array('packages::devel::postgres')
 
   package { $packages:
     ensure => present,
   }
+
+  file { '/etc/postgresql-common/pg_service.conf':
+    ensure  => file,
+    content => template('profile/postgres/pg_service.conf.erb'),
+  }
 }
diff --git a/templates/postgres/pg_service.conf.erb b/templates/postgres/pg_service.conf.erb
new file mode 100644
index 0000000..9594fbc
--- /dev/null
+++ b/templates/postgres/pg_service.conf.erb
@@ -0,0 +1,6 @@
+# This file is managed by puppet. Local modifications will be overwritten.
+
+[swh]
+dbname=softwareheritage
+host=db.internal.softwareheritage.org
+user=guest