On 07/03/2017 09:02, Panagiotis Atmatzidis wrote:
Hello,
I have 2 RDS instances on AWS running PSQL 9.4.7.
I want to make a clone of database1 which belongs to user1, to database2 which
belongs to user2. Database1 has 20+ tables. I want to avoid copying the DATA
sitting on 5 tables on databas
Thanks (again Adrian) and Tom.
The situation was that I had a table with 731million records which I wanted
to copy into a partitioned one where there was a unique constraint on the
fields used in my query.
The "backup" table was the single one.
While inserting into the partitioned table from the
On Tue, Mar 7, 2017 at 2:02 AM, Panagiotis Atmatzidis
wrote:
> I want to make a clone of database1 which belongs to user1, to database2
> which belongs to user2. Database1 has 20+ tables. I want to avoid copying
> the DATA sitting on 5 tables on database1 (many Gigs).
>
> I've read one too many p
Greetings,
* Stephen Frost (sfr...@snowman.net) wrote:
> * Frank van Vugt (ftm.van.v...@foxi.nl) wrote:
> > Well, I didn't run into this issue with any of my db's that 'nicely' use
> > tables in various schema's, it was actually the one 'older' db with
> > everything
> > in the public schema th
On 03/07/2017 01:22 AM, Johann Spies wrote:
Thanks (again Adrian) and Tom.
The situation was that I had a table with 731million records which I
wanted to copy into a partitioned one where there was a unique
constraint on the fields used in my query.
The "backup" table was the single one.
While
Hello,
I am attempting to get the tap tests working under windows so as to
help review patches for the 10.0 development cycle. I can compile
the sources on windows 2008 using the MS Visual C and run the
vcregress.bat check
without any problems or failures. In an attempt to run the tap
2017-03-07 21:04 GMT+01:00 Caleb Cushing :
> Thank you. Apparently I never saw this response, for some reason...
>
> So reading that leaves me confused on one point, which is the right way to
> do it if you're inserting an integer? would this be right? is there a
> difference between the single a
Trying to compile pgsql 9.6.2 on Fedora 25
I get the following message:
configure:9345: error: readline library not found
If you have readline already installed, see config.log for details on the
Use --without-readline to disable readline support.
pgac_cv_check_readline=no
libreadline does exis
On Tue, Mar 7, 2017 at 1:29 PM, Pavel Stehule
wrote:
>
>
> 2017-03-07 21:04 GMT+01:00 Caleb Cushing :
>
>> Thank you. Apparently I never saw this response, for some reason...
>>
>> So reading that leaves me confused on one point, which is the right way
>> to do it if you're inserting an integer?
Hi,
On Tue, 2017-03-07 at 15:38 -0500, John Iliffe wrote:
> Trying to compile pgsql 9.6.2 on Fedora 25
>
> I get the following message:
>
> configure:9345: error: readline library not found
Please install readline-devel.
(BTW, https://yum.PostgreSQL.org has 9.6.2 and Fedora 25 RPMs already)
Perfect! Thank you.
Same issue then occurred with zlib and I installed the dev pieces and it
worked too.
Might be a good idea if the documentation listed these somewhere as
prereqs. In the past all the servers I have worked on had these installed
already but this one is a bit basic.
Regard
> On Mar 7, 2017, at 12:24 PM, Mark Dilger wrote:
>
> Hello,
>
> I am attempting to get the tap tests working under windows so as to
> help review patches for the 10.0 development cycle. I can compile
> the sources on windows 2008 using the MS Visual C and run the
>
> vcregress.bat chec
On 03/07/2017 01:33 PM, John Iliffe wrote:
Perfect! Thank you.
Same issue then occurred with zlib and I installed the dev pieces and it
worked too.
Might be a good idea if the documentation listed these somewhere as
prereqs. In the past all the servers I have worked on had these installed
Hi. I've got a recurring problem with character encoding for a
Postgres-based web PHP app, and am hoping someone can clue me in or at
least point me in the right direction. I'll confess upfront my
understanding of encoding issues is extremely limited. Here goes.
The app uses a Postgres database
On Tue, Mar 7, 2017 at 4:20 PM, Ken Tanzer wrote:
> As I understand it, those are likely encoded in something non-UTF-8, like
> WIN-1251 or something. And that one way or another, the encoding needs to
> be translated before it can be placed into the database. I'm not clear how
> this is suppos
On 03/07/2017 03:20 PM, Ken Tanzer wrote:
Hi. I've got a recurring problem with character encoding for a
Postgres-based web PHP app, and am hoping someone can clue me in or at
least point me in the right direction. I'll confess upfront my
understanding of encoding issues is extremely limited.
Hi Ken,
On Tue, 2017-03-07 at 15:20 -0800, Ken Tanzer wrote:
> Hi. I've got a recurring problem with character encoding for a
> Postgres-based web PHP app, and am hoping someone can clue me in or
> at least point me in the right direction. I'll confess upfront my
> understanding of encoding issu
I was unable to get postgres started so I did a very basic compile/install
to test it. The configuration line was:
./configure --prefix=/usr/postgres-9.6.2
Then I ran make which completed as expected:
make[1]: Leaving directory '/tmp/postgresql-9.6.2/config'
Al
On Tue, Mar 7, 2017 at 11:17 PM, John Iliffe wrote:
> I was unable to get postgres started so I did a very basic compile/install
> to test it. The configuration line was:
>
> ./configure --prefix=/usr/postgres-9.6.2
>
>
> Then I ran make which completed as expect
Dear all,
Thanks for your support.
I need to perfrom INSERT and REINDEX operation exclusively.
For example:
If REINDEX operation is in progress then INSERT operation will wait and
vice versa.
Please let me know if any approach is available.
Regards,
Yogesh sharma
John Iliffe writes:
> Now, running as user postgres I try and start as stated in the manual
> postgres -D /usr/pgsql_tablespaces
> The result is:
> [postgres@prod04 postgresql-9.6.2]$ postgres -D /usr/pgsql_tablespaces
> LOG: could not bind IPv4 socket: Cannot assign requested address
> HINT: I
On 03/07/2017 08:17 PM, John Iliffe wrote:
I was unable to get postgres started so I did a very basic compile/install
to test it. The configuration line was:
./configure --prefix=/usr/postgres-9.6.2
Then I ran make which completed as expected:
make[1]: Leaving
On Tuesday, March 7, 2017, Yogesh Sharma wrote:
> Dear all,
>
> Thanks for your support.
>
> I need to perfrom INSERT and REINDEX operation exclusively.
> For example:
> If REINDEX operation is in progress then INSERT operation will wait and
> vice versa.
>
> Please let me know if any approach i
Dear David,
I want to apply explicitly lock mechanism once inset operation is in
progress then REINDEX will wait.
And vice versa.
So, please let me know this type of handling is possible.
Regrds,
Yogesh
On Wednesday, March 8, 2017, David G. Johnston
wrote:
> On Tuesday, March 7, 2017, Yogesh S
On Tue, Mar 7, 2017 at 11:21 PM, Yogesh Sharma wrote:
> Dear David,
>
> I want to apply explicitly lock mechanism once inset operation is in
> progress then REINDEX will wait.
> And vice versa.
> So, please let me know this type of handling is possible.
> Regrds,
> Yogesh
Create two roles grant
On Tue, Mar 7, 2017 at 11:55 PM, Scott Marlowe wrote:
> On Tue, Mar 7, 2017 at 11:21 PM, Yogesh Sharma wrote:
>> Dear David,
>>
>> I want to apply explicitly lock mechanism once inset operation is in
>> progress then REINDEX will wait.
>> And vice versa.
>> So, please let me know this type of ha
On 2017-03-08 00:20, Ken Tanzer wrote:
Hi. I've got a recurring problem with character encoding for a
Postgres-based web PHP app, and am hoping someone can clue me in or at
least point me in the right direction. I'll confess upfront my
understanding of encoding issues is extremely limited. Her
27 matches
Mail list logo
