Re: A Good Beginner's Book

[Anthony DeBarros]

Hi,

On Sat, Aug 12, 2023 at 6:23 PM Miles Elam 
wrote:

> > On 8/12/23 9:02 a.m., Amn Ojee Uw wrote:
> >
> > Is there a book to be recommended for PostgreSQL beginners?
>

I’m the author of Practical SQL from No Starch Press. My book combines an
intro to SQL with lessons on data analysis. Learn more at
https://practicalsql.com






>
>
>

Language Pack missing from StackBuilder (EDB Windows download)

[Anthony DeBarros]

While installing a fresh copy of PostgreSQL 15.3 downloaded from
EDB's website, I have discovered that the Language Pack usually present in
StackBuilder is missing.

Anyone here from EDB who might know if this is a temporary or a permanent
change?

I will try emailing EDB separately, but thought I would try here in case
someone from the company is reading.

Thanks,
Anthony

Where to flag an issue with EDB's PG15 Windows installer?

[Anthony DeBarros]

Hi,

Where is the appropriate place to file a concern/issue with the EDB
installer -- StackBuilder in particular -- for PostgreSQL 15 on Windows?

Thanks,
Anthony DeBarros

Re: Problems with installation on Mac OS

[Anthony DeBarros]

Hi,

El 23/4/22 a las 17:15, Daria Lesyk escribió:
>
> Hello,
> I'm trying to install PostgreSQL (the latest version) on Mac but the
> stackbuilder returns the following errors in the end of the installation of
> PostgreSQL.
> What I have to do to install that smoothly.
> Thank you in advance for your help.
>
>
Have you tried Postgres.app? Easy, quick install.

> https://postgresapp.com/

PostGIS missing from EDB Windows installer for PG13?

[Anthony DeBarros]

Good day,

I just tried a fresh install of PostgreSQL 13 on Windows using the EDB
installer, and I see that StackBuilder does not include an option to
install PostGIS. Anyone have insight on whether that's a permanent change
or not?

Thanks,

Anthony DeBarros
Author, "Practical SQL" from No Starch Press

Re: Backup PostgreSQL from RDS straight to S3

[Anthony DeBarros]

Great, thanks. The question I have, which at first glance isn't covered
there, is whether those instructions will at any point bring the dump file
onto the EC2 box, either in memory or temp file storage, on its way to S3?
I don't know enough about how Linux handles data piped from one command to
the next to know whether that's standard OP or not.

On Wed, Sep 18, 2019 at 2:36 PM Adrian Klaver 
wrote:

> On 9/18/19 11:32 AM, Anthony DeBarros wrote:
> > Hi, folks -- I'm a longtime PostgreSQL user but a bit of a noob when it
> > comes to maintenance. Question:
> >
> > I'm running PostgreSQL 11 on Amazon RDS. Also have an EC2 box running
> > Ubuntu that runs some Python scripts that collect data into PostgreSQL.
> >
> > We're doing the standard RDS backups. However, I'd also like to do a
> > nightly pg_dump and store that file on S3. Is there a way to go straight
> > from RDS to S3 without having to download the dump file onto the EC2 box
> > at any point? I want to avoid a scenario where the DB file fills the EC2
> > box's disk.
>
> ?:
>
> https://dba.stackexchange.com/questions/221454/best-way-to-pg-dump-postgresql-on-rds-to-s3
>
> >
> > Thanks for any and all advice!
> >
> > Anthony
> >
> >
>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>

Backup PostgreSQL from RDS straight to S3

[Anthony DeBarros]

Hi, folks -- I'm a longtime PostgreSQL user but a bit of a noob when it
comes to maintenance. Question:

I'm running PostgreSQL 11 on Amazon RDS. Also have an EC2 box running
Ubuntu that runs some Python scripts that collect data into PostgreSQL.

We're doing the standard RDS backups. However, I'd also like to do a
nightly pg_dump and store that file on S3. Is there a way to go straight
from RDS to S3 without having to download the dump file onto the EC2 box at
any point? I want to avoid a scenario where the DB file fills the EC2 box's
disk.

Thanks for any and all advice!

Anthony

Re: Plpythonu extension

[Anthony DeBarros]

Consider using Postgres.app instead?

On Wed, Feb 20, 2019 at 11:13 AM Adrian Klaver 
wrote:

> On 2/20/19 8:06 AM, Vincent Predoehl wrote:
> > Ok, thanks guys.  I already tried:
> >
> > brew install postgres --with-python
> >
> > With no success…
>
> See Peters post and it's link to:
>
> https://github.com/Homebrew/homebrew-core/pull/36074
>
> Seems options are no longer allowed in Homebrew.
>
> >
> >> On Feb 20, 2019, at 10:01 AM, Adrian Klaver  >> > wrote:
> >>
> >> On 2/20/19 6:46 AM, Vincent Predoehl wrote:
> >>> hi
> >>> I have PostgreSQL 11.1 installed on MacOS X Mojave and I used brew to
> >>> do the install.  It appears that the extension plpython was not
> >>> included in the default installation and I would like to know how to
> >>> install it.
> >>
> >> All I can find is:
> >>
> >>
> https://stackoverflow.com/questions/38062512/install-plpython-on-mac-with-python-2-7
> >>
> >> Not sure how helpful that is. Though it does seem to be an option here:
> >>
> >> https://formulae.brew.sh/formula/postgresql
> >>
> >> postgresql --with-python
> >>
> >> Otherwise you might try the Homebrew forum:
> >>
> >> https://discourse.brew.sh/latest
> >>
> >>> Thanks…
> >>
> >>
> >> --
> >> Adrian Klaver
> >> adrian.kla...@aklaver.com
> >
>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>
>

PLPython Setup issue with EDB Windows Installer

[Anthony DeBarros]

I sent a report to EDB about this, but since I'm not a support subscriber I
am not sure it will get through. Thought I would share here and seek some
tips or feedback.

---

Installing EDB Postgres Standard 10.4 on Windows 10 does not set up
PLPython support correctly. (I also installed the Language Pack via Stack
Builder.)

Following the installation, running CREATE EXTENSION plypythonu; generates
this error:
"ERROR: could not access file "$libdir/plpython2": No such file or
directory SQL state: 58P01"

Trying CREATE EXTENSION plpython3u; generates this error:
"Could not load library "C:/Program Files/PostgreSQL/10/lib/plpython3.dll":
The specified module could not be found "

To track down the issue, I used Dependency Walker (
http://www.dependencywalker.com/) to examine plpython3.dll, which is stored
in the Postgres /lib directory. That DLL is looking for the file
python34.dll to be located in C:\windows\system32, but the EBD installer
doesn't place it there.

The solution is to copy python34.dll into C:\windows\system32 from the
language pack files. Once python34.dll is present in C:\windows\system32,
then you can create the language.

This is a bit annoying and not easily solvable for a typical user!

Anyone here from EDB who can address the issue?

Thanks,
Anthony DeBarros