Eric MacAdie writes:
> One thing that is different about Postgres is that it uses a lot of
> "meta-commands".
> https://www.postgresql.org/docs/current/app-psql.html
> An important one is "\q", which exits you from the database. Typing
> "quit" or "exit" won't get you out of the session.
Actually
One thing that is different about Postgres is that it uses a lot of
"meta-commands".
https://www.postgresql.org/docs/current/app-psql.html
An important one is "\q", which exits you from the database. Typing
"quit" or "exit" won't get you out of the session.
= Eric MacAdie
On Mon, Mar 30, 2020 a
On Sat, Mar 28, 2020 at 05:53:59PM +0900, Michael Paquier wrote:
> And I'll follow up there with anything new I find. Please let me know
> if there are any objections with the revert though, this will address
> the problem reported by Justin.
Okay. Done with this part now as of dd9ac7d. Now for
On 2020-03-31 06:30, Kevin Brannen wrote:
From: Turritopsis Dohrnii Teo En Ming
Is PostgreSQL SQL database command syntax similar to MySQL/MariaDB?
If you stuck to "standard SQL" in Mysql, you'll generally be fine; the
differences will be pretty minor. The further you strayed from the
stand
On 2020-03-30 21:26, Wim Bertels wrote:
Turritopsis Dohrnii Teo En Ming schreef op ma 30-03-2020 om 20:49
[+0800]:
Good evening from Singapore,
Is PostgreSQL SQL database command syntax similar to MySQL/MariaDB?
Unfortunately mysql/mariadb syntax differs in general more than others
dbms from
From: Turritopsis Dohrnii Teo En Ming
> Is PostgreSQL SQL database command syntax similar to MySQL/MariaDB?
If you stuck to "standard SQL" in Mysql, you'll generally be fine; the
differences will be pretty minor. The further you strayed from the standard
will cause you more work -- usually. T
On Mon, Mar 30, 2020 at 4:30 PM Tom Lane wrote:
> Don Seiler writes:
> > Actually, would I need to re-index on text columns that we know contain
> > UUID strings? UUID characters seem to be pretty basic alphanumeric ASCII
> > characters.
>
> I think you're all right with respect to those, since
Don Seiler writes:
> Actually, would I need to re-index on text columns that we know contain
> UUID strings? UUID characters seem to be pretty basic alphanumeric ASCII
> characters.
I think you're all right with respect to those, since they're the
same under any encoding. It's columns containing
On Sun, Mar 22, 2020 at 4:48 PM Don Seiler wrote:
>
> Here's the fun part. A lot of the tables use UUIDv4 strings for primary
> keys. However these are stored in text/varchar columns.
>
Actually, would I need to re-index on text columns that we know contain
UUID strings? UUID characters seem to
On 3/30/20 11:36 AM, Adrian Klaver wrote:
On 3/30/20 11:06 AM, Andrus wrote:
Hi!
Got it. Just thought it would be easier not to have to deal with
cross OS issues.
Here is one example:
https://www.pgpool.net/docs/latest/en/html/example-watchdog.html
Hopefully Windows Hyper-V virtual network
On 3/30/20 11:06 AM, Andrus wrote:
Hi!
Got it. Just thought it would be easier not to have to deal with cross
OS issues.
Here is one example:
https://www.pgpool.net/docs/latest/en/html/example-watchdog.html
Hopefully Windows Hyper-V virtual network adapter will not check windows
20 connecti
Hi!
Not sure but:
1) I was on Windows 7
2) Using Postgres 11
3) My Windows skills have atrophied, especially with the Windows command
line.
So was this the same for the database you originally posted about, it
actually restored it just threw warnings?
Looks like it restored. I havent checke
Hi!
Got it. Just thought it would be easier not to have to deal with cross OS
issues.
Here is one example:
https://www.pgpool.net/docs/latest/en/html/example-watchdog.html
Hopefully Windows Hyper-V virtual network adapter will not check windows 20
connection limit.
In this case using Debian+
On 3/29/20 2:47 PM, Andrus wrote:
Hi!
Same warning appears two times. This command execute by pg_restore
probably causes this (harmless?) warning:
What warning?
pg_restore: WARNING: could not determine encoding for locale
"et_EE.UTF-8":
codeset is "CPUTF-8"
I cranked up a Windows 7 inst
On 3/29/20 11:35 PM, Andrus wrote:
Hi!
Would it not be easier to just set up another Debian server, run
binary replication
Breaks occurs rarely, 0-2 times per year.
I want try it first.
Got it. Just thought it would be easier not to have to deal with cross
OS issues.
and put them behi
On 3/29/20 10:33 PM, Aisar Afif Ahmad Norzan wrote:
Hi,
Few weeks back, I upload my data (shapefile) directly to the geoserver.
Last week, I just installed postgresql. How can I link the existing file
in geoserver (shapefiles) to postgres using pgAdmin 4.
I assume by geoserver you mean:
htt
Turritopsis Dohrnii Teo En Ming schreef op ma 30-03-2020 om 20:49
[+0800]:
> Good evening from Singapore,
>
> Is PostgreSQL SQL database command syntax similar to MySQL/MariaDB?
Unfortunately mysql/mariadb syntax differs in general more than others
dbms from the iso/ansi sql standard.
>
> Becau
po 30. 3. 2020 v 15:06 odesílatel Turritopsis Dohrnii Teo En Ming <
c...@teo-en-ming.com> napsal:
> On 2020-03-30 21:03, Pavel Stehule wrote:
> > po 30. 3. 2020 v 14:49 odesílatel Turritopsis Dohrnii Teo En Ming
> > napsal:
> >
> >> Good evening from Singapore,
> >>
> >> Is PostgreSQL SQL databas
On 2020-03-30 21:03, Pavel Stehule wrote:
po 30. 3. 2020 v 14:49 odesílatel Turritopsis Dohrnii Teo En Ming
napsal:
Good evening from Singapore,
Is PostgreSQL SQL database command syntax similar to MySQL/MariaDB?
Because I have never used PostgreSQL before.
I am looking forward to hearing f
po 30. 3. 2020 v 14:49 odesílatel Turritopsis Dohrnii Teo En Ming <
c...@teo-en-ming.com> napsal:
> Good evening from Singapore,
>
> Is PostgreSQL SQL database command syntax similar to MySQL/MariaDB?
>
> Because I have never used PostgreSQL before.
>
> I am looking forward to hearing from you soo
Good evening from Singapore,
Is PostgreSQL SQL database command syntax similar to MySQL/MariaDB?
Because I have never used PostgreSQL before.
I am looking forward to hearing from you soon.
Thank you.
-BEGIN EMAIL SIGNATURE-
The Gospel for all Targeted Individuals (TIs):
[The N
On Mon, 2020-03-30 at 11:02 +0530, Shishir Joshi wrote:
> On Fri, 27 Mar 2020 at 19:30, Tom Lane wrote:
> > Shishir Joshi writes:
> > > I recently faced an issue with PG 11 where the VM that the PG process was
> > > running on got restarted because of a hardware issue. After the VM
> > > restart
Hi,
Few weeks back, I upload my data (shapefile) directly to the geoserver.
Last week, I just installed postgresql. How can I link the existing file in
geoserver (shapefiles) to postgres using pgAdmin 4.
Regards,
Aisar
Hi Tom,
I forgot to mention, but in this case it looks the mount was completed
before the PG process was started up. But we don't have an explicit check
for making sure the file system is present in the start script. Thanks for
the tip.
On Fri, 27 Mar 2020 at 19:30, Tom Lane wrote:
> Shishir Jos
24 matches
Mail list logo
