Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tIj4P-00G95k-4d for pgsql-sql@arkaria.postgresql.org; Wed, 04 Dec 2024 06:41:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tIj4L-00FNQv-9o for pgsql-sql@arkaria.postgresql.org; Wed, 04 Dec 2024 06:41:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tIj4K-00FNQn-VP for pgsql-sql@lists.postgresql.org; Wed, 04 Dec 2024 06:41:06 +0000 Received: from mail-wr1-x433.google.com ([2a00:1450:4864:20::433]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tIj4E-000xvu-BA for pgsql-sql@lists.postgresql.org; Wed, 04 Dec 2024 06:41:05 +0000 Received: by mail-wr1-x433.google.com with SMTP id ffacd0b85a97d-385e1721716so2437959f8f.3 for ; Tue, 03 Dec 2024 22:40:58 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1733294457; x=1733899257; darn=lists.postgresql.org; h=mime-version:user-agent:references:in-reply-to:date:cc:to:reply-to :from:subject:message-id:from:to:cc:subject:date:message-id:reply-to; bh=eRaAy61EMsytN0xsgIHxZVt9Btd1XzMiwdrXE0kIwrY=; b=YgPEkob5I/5bjoz2Vf+HZbtJMAhw6/o8PkU06e/C5rUVkKEjFCiT3DAwtkwpg5CWZR 1WmuIN+Z2agY1IV0WGMARk56kbqz43VhjZrrGYfxrbNQn8B1j617wH8GzZ3JpoTBut3s +9svxeDNi2TP8gJhdLtCgsBAyQLU6YXN/hkr0oPJYBtaAVb8ud6Fm8XB5MzPQAWDbMVw Zpy3k0cSQZD+pyhf6CES2SCsehDGTJ+uKdHYerZsbJ5wVR98rzWToxXsidJC7lRqG1Oi cmYDJKhqpNPW9Bo95kr9D7RGNZcw76FQ7n3c8LAEUdzuqLraCJ/2jSxjEFj0zDu6kOE1 VeMA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1733294457; x=1733899257; h=mime-version:user-agent:references:in-reply-to:date:cc:to:reply-to :from:subject:message-id:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=eRaAy61EMsytN0xsgIHxZVt9Btd1XzMiwdrXE0kIwrY=; b=V/ZZUqP8WG1r5NOdnDLSVl26D0Zu/ZpaNzlqQ5BuW09fH3P3z7hslCfJhR9xMaggTX hDAWIdWP+o8TO5IS4qvWFChefPP7bfFTSK3bBl52h6DyQB53itDpFOI0RKoUUUId4aUg 0WUCD0N8SQMq2p1h2VOy6/7n2d2tq11AXmLvlz6liB1e4WXEJPKcw3L+LA2gk9bjYqsI YqDF/jE6N8fv7lk5KCVJRECitP/+uvS+VatGPuaFOENqHUP75cyH8WL/leYMApVyUHVH t1m1BoOHdbrXK05NrQXnBxsNC5S8p1Ahk+Ijzd516UEuV3e7+hox4Ypq+14COEUmvYqL U3dw== X-Gm-Message-State: AOJu0YxhIG4K4661Vb+Gsp6NW/ejtMruyd92imwFny0Upqkw+IZgvkFA zBS4sAMrmTxdoTSnz0W7rJBzHU32Ms53/eKRYFnQcrOwWtpYiTez X-Gm-Gg: ASbGncsguhf/L7ZYqfXhZJKEu+xKU9Lg8xezpTq6wBSYD+d5YPSaxPsdQIB7VMn5LtJ xyHaBe4DVn3ni7g85Rcc5V6Ps5jx1wxaqrseHd1//eg+nXDvjPSKw4Zqzyy0ra/hXsWsSrPtKuv PNYn6ozuH0CVSQjirl1BtC6Q5jkHqpYcMKwFpAGKIyYWOEL0s83Gf5rZMWiYCVBLgOyhRwd66Ez SM1Po5m5lLi1pbB6T02GXzJLo81whOA5NicKfqTwJ1SEaMfISBc X-Google-Smtp-Source: AGHT+IHVWTmYjtcvPoKcFz+VXk9vcwmC9yhhUk0LQsjl9OhaVLvUctpTnkjaU9gRNZi90IU1A2U6Xw== X-Received: by 2002:a5d:6f15:0:b0:385:e01b:7df5 with SMTP id ffacd0b85a97d-385fd3cd05emr4751841f8f.14.1733294456547; Tue, 03 Dec 2024 22:40:56 -0800 (PST) Received: from [10.1.14.152] ([159.20.26.60]) by smtp.googlemail.com with ESMTPSA id 5b1f17b1804b1-434d52b66ecsm12853405e9.39.2024.12.03.22.40.55 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 03 Dec 2024 22:40:55 -0800 (PST) Message-ID: Subject: Re: Request for PostgreSQL Resources and Documentation From: Andrew Cilia Reply-To: indri.cilia@gmail.com To: Steve Midgley , Suat Mollasalihoglu Cc: pgsql-sql@lists.postgresql.org Date: Wed, 04 Dec 2024 07:40:54 +0100 In-Reply-To: References: Content-Type: multipart/alternative; boundary="=-lreA2Y2qu6mH75ic6WcK" User-Agent: Evolution 3.52.4 (3.52.4-2.fc40) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-lreA2Y2qu6mH75ic6WcK Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Continuing on from Steve's recommendations, I'd say install two instances s= o that you can practise replication and manage it through pgadmin. No need for two machines. Just g= et them running off different ports. It helped me a good deal when I sat for my certification. On Tue, 2024-12-03 at 11:30 -0800, Steve Midgley wrote: >=20 >=20 > On Tue, Dec 3, 2024 at 11:21=E2=80=AFAM Suat Mollasalihoglu wrote: > > Dear PostgreSQL Experts, > > I hope this email finds you well. My name is [Your Name], and I am curr= ently working as a > > PostgreSQL Database Administrator at a company developing financial sof= tware. > > As part of my professional development, I am committed to mastering Pos= tgreSQL in all its > > intricacies. I would be deeply grateful if you could share any resource= s, documentation, or > > recommendations that might help deepen my understanding and skills with= PostgreSQL. > > If there are specific guides, best practices, or advanced topics you be= lieve would be > > particularly useful for someone in my field, I would be thrilled to rec= eive your suggestions. > > Thank you in advance for your time and assistance. I truly appreciate t= he wealth of knowledge > > shared by the PostgreSQL community and hope to contribute back in the f= uture. > > Best regards, > > Suat MOLLASAL=C4=B0HO=C4=9ELU > >=20 > The documentation on the main site is spectacularly good, in my > opinion:=C2=A0https://www.postgresql.org/docs/current/index.html >=20 > My input for how to move forward with learning Pg: > * Download the server and install it.=20 > * Pick some interesting data projects that you want to solve > * Work through the docs to get your orientation > * Use GPT4-o (or Claude 3.5 Sonnet) and Stackoverflow to help you figure= out any details that you > get stuck on > * Use this list to get help when you can't move forward >=20 --=-lreA2Y2qu6mH75ic6WcK Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable
Continuing on from Steve's recommendations, I'd s= ay install two instances so that you can practise replication and manage it= through pgadmin. No need for two machines. Just get them running off diffe= rent ports. It helped me a good deal when I sat for my certification.
=


On Tue, 2024-12-03 at 11:30 -0800, Steve= Midgley wrote:


On Tue, Dec 3, 2024 at 11:21=E2=80=AFAM = Suat Mollasalihoglu <mol= lasalihoglusuat@gmail.com> wrote:

Dear PostgreSQL Experts,

I hope this email find= s you well. My name is [Your Name], and I am currently working as a Postgre= SQL Database Administrator at a company developing financial software.

<= p>As part of my professional development, I am committed to mastering Postg= reSQL in all its intricacies. I would be deeply grateful if you could share= any resources, documentation, or recommendations that might help deepen my= understanding and skills with PostgreSQL.

If there are specific guid= es, best practices, or advanced topics you believe would be particularly us= eful for someone in my field, I would be thrilled to receive your suggestio= ns.

Thank you in advance for your time and assistance. I truly apprec= iate the wealth of knowledge shared by the PostgreSQL community and hope to= contribute back in the future.

Best regards,
Suat MOLLASAL=C4=B0H= O=C4=9ELU


The documentation on the main site= is spectacularly good, in my opinion: https://www.postgresql.org/docs/current/ind= ex.html

My input for how to move forward with = learning Pg:
  • Download the server and install it.
  • Pick= some interesting data projects that you want to solve
  • Work through= the docs to get your orientation
  • Use GPT4-o (or Claude 3.5 Sonnet)= and Stackoverflow to help you figure out any details that you get stuck on=
  • Use this list to get help when you can't move forward


--=-lreA2Y2qu6mH75ic6WcK--