Thanks all,
Is pg_upgrade is the best method if I am doing upgrade on same server or
different server.
Same server means: source and Target on same server
Different: source and Target are different server.
On Mon, Jun 10, 2019, 12:07 PM Michael Paquier wrote:
> On Mon, Jun 10, 2019 at 09:00:
On Mon, Jun 10, 2019 at 09:00:38AM +0300, Achilleas Mantzios wrote:
> On 10/6/19 7:36 π.μ., Pawan Sharma wrote:
>> What is the best way to upgrade from PostgreSQL 9.6 to PostgreSQL
>> 11 instead of pg_upgrade.
>
> why not pg_upgrade ? If the size is near the 3TB mark as you say,
> pg_upgrade is the
On 10/6/19 7:36 π.μ., Pawan Sharma wrote:
Hello All.
What is the best way to upgrade from PostgreSQL 9.6 to PostgreSQL 11 instead of
pg_upgrade.
why not pg_upgrade ? If the size is near the 3TB mark as you say, pg_upgrade is
the fastest IMHO.
- Less downtime.
- Approx database size are 1-3
Hi, Adrian,
On Sun, Jun 9, 2019 at 11:14 PM Adrian Klaver wrote:
>
> On 6/9/19 8:28 AM, Igor Korot wrote:
> > Hi, ALL,
> > How do I insert the png file (content, not a name) into the BLOB field
> > in the table i PostgreSQL DB?
>
> Are you talking about this data type?:
>
> https://www.postgresql
Hello All.
What is the best way to upgrade from PostgreSQL 9.6 to PostgreSQL 11
instead of pg_upgrade.
- Less downtime.
- Approx database size are 1-3TB.
Thanks for your help..!!!
Regards,
Pawan
On 6/9/19 8:28 AM, Igor Korot wrote:
Hi, ALL,
How do I insert the png file (content, not a name) into the BLOB field
in the table i PostgreSQL DB?
Are you talking about this data type?:
https://www.postgresql.org/docs/11/datatype-binary.html
Or this?:
https://www.postgresql.org/docs/11/large
Hi, ALL,
How do I insert the png file (content, not a name) into the BLOB field
in the table i PostgreSQL DB?
Thank you.
Drexl Spivey schrieb am 10.06.2019 um 04:45:
> It seems in my little database development experience that this is
> one area where windows might actually offer the best, most
> mature/developed choices. If this is the case, I should acclimate
> myself to it more.
>
> I have found many applications
Drexl Spivey writes:
> Is database work heavily windows leaning??
FWIW, I don't know of *any* mainstream database server, other than
Microsoft's own SQL Server, that considers Windows to be a preferred
platform. It's definitely the last choice so far as Postgres is
concerned; maybe you'd get mor
On 6/9/19 2:45 PM, Drexl Spivey wrote:
Hello all,
Don't want to start one of those endless internet tug of wars without
end threads, but would like some other people's opinions.
First off, I use all Operating systems without problems, personally
defaulting to linux at home, but mostly mac at
On 10/06/2019 09:45, Drexl Spivey wrote:
Hello all,
Don't want to start one of those endless internet tug of wars without
end threads, but would like some other people's opinions.
First off, I use all Operating systems without problems, personally
defaulting to linux at home, but mostly mac
Drexl Spivey writes:
> Hello all,
>
> Don't want to start one of those endless internet tug of wars without end
> threads, but would like some other people's opinions.
>
> First off, I use all Operating systems without problems, personally
> defaulting to linux at home, but mostly mac at work
On 6/9/19 4:45 PM, Drexl Spivey wrote:
Hello all,
Don't want to start one of those endless internet tug of wars without end
threads, but would like some other people's opinions.
First off, I use all Operating systems without problems, personally defaulting
to linux at home, but mostly mac at
Hello all,
Don't want to start one of those endless internet tug of wars without end
threads, but would like some other people's opinions.
First off, I use all Operating systems without problems, personally defaulting
to linux at home, but mostly mac at work. I use windows, when necessary, not
On 6/9/19 1:46 PM, Ray O'Donnell wrote:
On 09/06/2019 20:49, Sourav Majumdar wrote:
Hello,
Thanks for your quick response. I am new to pgsql, didnot configured
it , can you please give a guidance for that? I will be highly oblised
if you can assist me.
I am using windows 8.1, 64 bit.
ruby 2.3
On 6/9/19 1:46 PM, Ray O'Donnell wrote:
On 09/06/2019 20:49, Sourav Majumdar wrote:
Hello,
Thanks for your quick response. I am new to pgsql, didnot configured
it , can you please give a guidance for that? I will be highly oblised
if you can assist me.
I am using windows 8.1, 64 bit.
ruby 2.3
On 09/06/2019 20:49, Sourav Majumdar wrote:
Hello,
Thanks for your quick response. I am new to pgsql, didnot configured it
, can you please give a guidance for that? I will be highly oblised if
you can assist me.
I am using windows 8.1, 64 bit.
ruby 2.3.3p222 (2016-11-21 revision 56859) [i386-
(sorry, very old thread)
On Fri, Mar 15, 2013 at 09:38:06AM -0400, Tom Lane wrote:
> Bill Moran writes:
> > I do wonder what else is happening in the transaction that you're
> > calling NOTIFY within; and that some other statement could be causing
> > the lock wait.
>
> FWIW, the lock seems to b
On 09/06/2019 19:51, Sourav Majumdar wrote:
could not connect to server: Connection refused (0x274D/10061)
Is the server running on host "localhost" (::1) and accepting TCP/IP
connections on port 5432? could not connect to server: Connection
refused (0x274D/10061) Is the
On 6/9/19 11:51 AM, Sourav Majumdar wrote:
could not connect to server: Connection refused (0x274D/10061)
Is the server running on host "localhost" (::1) and accepting TCP/IP
connections on port 5432? could not connect to server: Connection
refused (0x274D/10061) Is the s
could not connect to server: Connection refused (0x274D/10061) Is the
server running on host "localhost" (::1) and accepting TCP/IP connections
on port 5432? could not connect to server: Connection refused
(0x274D/10061) Is the server running on host "localhost" (127.0.0.1)
and accepting TC
21 matches
Mail list logo
