Thanks, Adrian. It's running now.
On Mon, Nov 12, 2018 at 5:05 PM Adrian Klaver
wrote:
> On 11/12/18 1:58 PM, David wrote:
>
> Please reply to list also.
> Ccing list
>
> > Yes, that's what I get for writing emails while I'm doing 5 other things
> > at the same time. So, let me try this again.
On 11/12/18 2:07 PM, raf wrote:
Tom Lane wrote:
David writes:
I have some experience with different versions of Postgres, but I'm just
getting around to using pg_restore, and it's not working for me at all.
...
But a matching pg_restore command does nothing.
pg_restore -U postgres -f predata.
Tom Lane wrote:
> David writes:
> > I have some experience with different versions of Postgres, but I'm just
> > getting around to using pg_restore, and it's not working for me at all.
> > ...
> > But a matching pg_restore command does nothing.
> > pg_restore -U postgres -f predata.sql -v
>
> Th
raf wrote:
> Tom Lane wrote:
>
> > David writes:
> > > I have some experience with different versions of Postgres, but I'm just
> > > getting around to using pg_restore, and it's not working for me at all.
> > > ...
> > > But a matching pg_restore command does nothing.
> > > pg_restore -U postgr
On 11/12/18 1:58 PM, David wrote:
Please reply to list also.
Ccing list
Yes, that's what I get for writing emails while I'm doing 5 other things
at the same time. So, let me try this again.
pg_dump is working when I use the following:
pg_dump -U postgres -F d -f /pgbackup/prod/data -v --secti
On 11/12/18 11:39 AM, David wrote:
I'm not following your question. The pre-data and post-data sections
each go to an individual file, but the data section goes to a
directory. I can restore the files using psql, but it is the restore of
the directory that is hanging.
That is not what you s
On 11/12/18 2:06 PM, Tom Lane wrote:
Rob Sargent writes:
On 11/12/18 12:39 PM, David wrote:
I'm not following your question. The pre-data and post-data sections
each go to an individual file, but the data section goes to a
directory. I can restore the files using psql, but it is the restore
Rob Sargent writes:
> On 11/12/18 12:39 PM, David wrote:
>> I'm not following your question. The pre-data and post-data sections
>> each go to an individual file, but the data section goes to a
>> directory. I can restore the files using psql, but it is the restore
>> of the directory that is
On 11/12/18 12:39 PM, David wrote:
I'm not following your question. The pre-data and post-data sections
each go to an individual file, but the data section goes to a
directory. I can restore the files using psql, but it is the restore
of the directory that is hanging.
On Mon, Nov 12, 2018
I'm not following your question. The pre-data and post-data sections each
go to an individual file, but the data section goes to a directory. I can
restore the files using psql, but it is the restore of the directory that
is hanging.
On Mon, Nov 12, 2018 at 2:28 PM Rob Sargent wrote:
>
> On 11
On 11/12/18 11:44 AM, Tom Lane wrote:
David writes:
I have some experience with different versions of Postgres, but I'm just
getting around to using pg_restore, and it's not working for me at all.
...
But a matching pg_restore command does nothing.
pg_restore -U postgres -f predata.sql -v
Th
Thank you very much Rob, that concept worked out nicely. I would never have
thought of unioning the table to itself with unnest.
Here's my final query:
select environment ||':' || string_agg(name, ',')
from (
select name,environment from servers union select name,unnest(auditenvironmen
David writes:
> I have some experience with different versions of Postgres, but I'm just
> getting around to using pg_restore, and it's not working for me at all.
> ...
> But a matching pg_restore command does nothing.
> pg_restore -U postgres -f predata.sql -v
This command expects to read from s
On 11/12/18 10:37 AM, David wrote:
I can connect with psql either of these two ways:
psql -U postgres
or
psql -h ip-172-31-62-127.ec2.internal -p 5432 -U postgres -W postgres
(Yes, it's an AWS server)
This pg_dump command works:
pg_dump -U postgres -f predata.sql -F p -v -d prod_data
But a ma
I have some experience with different versions of Postgres, but I'm just
getting around to using pg_restore, and it's not working for me at all.
I can connect with psql, and pg_dump works, but pg_restore never does
anything when I call it. It never even prompts for a password.
Here is my pg_hba.
I need the version without installer. But the
But the version 11.1 located at:
https://www.enterprisedb.com/products-services-training/pgbindownload
(and suggested by the Thomas Kellerer in a parallel answer) works without
problems...
Thank you,
Marko Krajnc
On Mon, Nov 12, 2018 at 3:47 PM A
> On Nov 12, 2018, at 9:40 AM, Scot Kreienkamp
> wrote:
> …
I’m not too confident in my answer here (there could be a better way), but this
might help. You could use the `unnest` function to transform the array into
multiple rows. For example, given a table like
create table t1 (env t
Marko Krajnc schrieb am 12.11.2018 um 11:19:
> I just downloaded the letest version of PostgreSQL for Windows -
> v11.0-1 (as a ZIP archive here:
> https://www.enterprisedb.com/download-postgresql-binaries) and
> started the initdb.exe to initialize the database, but I get the
> message that libwin
On 11/12/18 6:45 AM, Karl Martin Skoldebrand wrote:
Thanks,
https://www.postgresql.org/docs/10/release.html
That's a massive list. But going for the first major release makes it
manageable.
Project policy is to only make feature changes on major version
releases, so hitting only these wil
On 11/12/18 2:19 AM, Marko Krajnc wrote:
Hi!
I just downloaded the letest version of PostgreSQL for Windows - v11.0-1
(as a ZIP archive here:
https://www.enterprisedb.com/download-postgresql-binaries) and started
From the above:
"The links below allow you to download archives of the files
Thanks,
>https://www.postgresql.org/docs/10/release.html
That's a massive list. But going for the first major release makes it
manageable.
> ---
>To be more certain I would set up a dev database with the new version and test
>against >that.
Aye, we've got a production and a test server. We'r
Hi everyone,
I had a dataset like so:
Servername|Primary class
--
Server1| retail
Server2| dmz
Server3 | NA
And I used this query to summarize it for automated tools:
select environment|| ':' || string_agg(name,',') from servers group by
environment order by e
Hi!
I just downloaded the letest version of PostgreSQL for Windows - v11.0-1
(as a ZIP archive here:
https://www.enterprisedb.com/download-postgresql-binaries) and started the
initdb.exe to initialize the database, but I get the message that
libwinpthread-1.dll is missing. PgAdmin 4 works out of t
On 11/12/18 1:17 AM, Karl Martin Skoldebrand wrote:
Are there any recommendations regarding upgrading from PG 9.3 to 9.6 or
10.x?
I found a few changes at
https://severalnines.com/blog/upgrading-your-database-to-postgresql-version-10
but are there more things to keep in mind regarding changes
On 11/12/2018 07:55 AM, Rich Shepard wrote:
On Sun, 11 Nov 2018, Ron wrote:
Unless your db is small, do a parallel dump. Even then, do a "-Fc" backup
instead. That's been the recommended method for many years.
Ron,
I've several databases, none 'large.' When I've used pg_dumpall in the
past
On Sun, 11 Nov 2018, Ron wrote:
Unless your db is small, do a parallel dump. Even then, do a "-Fc" backup
instead. That's been the recommended method for many years.
Ron,
I've several databases, none 'large.' When I've used pg_dumpall in the
past it's always with the clean option (-c) and t
Thanks for your input.
/M.
Disclaimer: This message and the information contained herein is proprietary
and confidential and subject to the Tech Mahindra policy statement
po 12. 11. 2018 v 11:45 odesílatel Karl Martin Skoldebrand <
ks0c77...@techmahindra.com> napsal:
> I found a note on logical replication in PostgreSQL 10.x with the caveat
> “There are also a number of caveats regarding what objects are actually
> replicated—for example, only tables are replicated
I found a note on logical replication in PostgreSQL 10.x with the caveat "There
are also a number of caveats regarding what objects are actually replicated-for
example, only tables are replicated, such objects as views and sequences are
not."
Does replication in 10.x now include views etc? We h
Hi
po 12. 11. 2018 v 10:18 odesílatel Karl Martin Skoldebrand <
ks0c77...@techmahindra.com> napsal:
> Are there any recommendations regarding upgrading from PG 9.3 to 9.6 or
> 10.x?
>
> I found a few changes at
> https://severalnines.com/blog/upgrading-your-database-to-postgresql-version-10
> but
Are there any recommendations regarding upgrading from PG 9.3 to 9.6 or 10.x?
I found a few changes at
https://severalnines.com/blog/upgrading-your-database-to-postgresql-version-10
but are there more things to keep in mind regarding changes in scripts/queries
that might affect an already existi
31 matches
Mail list logo
