Adrian Klaver escreveu
> On 10/27/2015 07:29 PM, Edson Richter wrote:
> > Hi!
> >
> > Using PostgreSQL 9.3.10 x86_64 Oracle EL7 compiled by gcc (GCC) 4.8.3
> > 20140911, installed using yum repository.
> >
> > In postgresql.conf, I do have:
> >
> > timezone="America/Sao_Paulo"
> >
> >
On 10/27/2015 07:29 PM, Edson Richter wrote:
Hi!
Using PostgreSQL 9.3.10 x86_64 Oracle EL7 compiled by gcc (GCC) 4.8.3
20140911, installed using yum repository.
In postgresql.conf, I do have:
timezone="America/Sao_Paulo"
Since DST is in place in Brazil, it is enough to "systemctl reload
postg
On 10/27/2015 04:10 PM, anj patnaik wrote:
I am running pg_dump on a database while on another machine running a
loop to do insertions.
Does pg_dump wait for idle activity before it completes or how does it
determine when it has all the records needed for archiving?
http://www.postgresql.org/d
I am running pg_dump on a database while on another machine running a loop
to do insertions.
Does pg_dump wait for idle activity before it completes or how does it
determine when it has all the records needed for archiving?
I am using the compressed mode and also using xz.
Thanks,
ap
Thank you for your reply.
1. I'm sure the io is not problem .but I didn't record the IO status at that
time.
2.what is THP compaction ? How can i rule this out?
3. explain
tshow=> explain select count(t.*) from tshow.res_room_weight
t,tshow.res_room_info r
tshow-> where t.subcatlg_id=46
Thank you for your reply. i will try to change it and Waiting for it to
appear again.the sql is :
select count(t.*) into o_count from tshow.res_room_weight
t,tshow.res_room_info r
where t.subcatlg_id=:i_title_id
and t.roomid = r.actorid
and r.levels>=0;
tshow=> \d res_room_info;
Hi!
Using PostgreSQL 9.3.10 x86_64 Oracle EL7 compiled by gcc (GCC) 4.8.3
20140911, installed using yum repository.
In postgresql.conf, I do have:
timezone="America/Sao_Paulo"
Since DST is in place in Brazil, it is enough to "systemctl reload
postgresql-9.3" to make it effective?
Or a comp
On Tue, Oct 27, 2015 at 4:04 PM, Merlin Moncure wrote:
> On Tue, Oct 27, 2015 at 2:33 PM, Jeff Janes wrote:
>> On Mon, Oct 26, 2015 at 8:30 PM, 657985...@qq.com <657985...@qq.com> wrote:
>>>
>>> Dear sir:
>>> Recently a wired question about postgresql database really
>>> bothered me a lo
On Tue, Oct 27, 2015 at 2:33 PM, Jeff Janes wrote:
> On Mon, Oct 26, 2015 at 8:30 PM, 657985...@qq.com <657985...@qq.com> wrote:
>>
>> Dear sir:
>> Recently a wired question about postgresql database really
>> bothered me a lot, so i really need your help. Here is the problem, in the
>> m
On Mon, Oct 26, 2015 at 8:30 PM, 657985...@qq.com <657985...@qq.com> wrote:
> Dear sir:
> Recently a wired question about postgresql database really
> bothered me a lot, so i really need your help. Here is the problem, in the
> most situations the postgre database work very well, Average
On Tue, Oct 27, 2015 at 12:14 PM, Bill Moran wrote:
> On Tue, 27 Oct 2015 11:30:45 +0800
> "657985...@qq.com" <657985...@qq.com> wrote:
>
>> Dear sir:
>> Recently a wired question about postgresql database really bothered
>> me a lot, so i really need your help. Here is the problem, in t
On Tue, 27 Oct 2015 11:30:45 +0800
"657985...@qq.com" <657985...@qq.com> wrote:
> Dear sir:
> Recently a wired question about postgresql database really bothered
> me a lot, so i really need your help. Here is the problem, in the most
> situations the postgre database work very well, A
Folks,
I will be travelling to Indianapolis Dec. 2-4. If there are some
PostgreSQL users in that area, I'd love to do an evening event and give
a talk on something, like replication, performance, or 9.5 features.
Right now I need at least a couple people to respond to this (off-list,
probably),
On 10/27/2015 09:36 AM, Melvin Davidson wrote:
The trick is to tell postgres where the data ends with \.
That is for all the data. What the OP was referring to was designating
where each row in the data ended.
From http://www.postgresql.org/docs/9.3/interactive/sql-copy.html
End of data
On Tue, Oct 27, 2015 at 12:36 PM, Melvin Davidson
wrote:
>
> contents of /tmp/junk.data:
> ---
> 1,'junk1'
> 2,'junk1'
> 3,'junk1'
>
Good info but I resonably certain the format in question is more like:
1,'ju
The trick is to tell postgres where the data ends with \.
>From http://www.postgresql.org/docs/9.3/interactive/sql-copy.html
End of data can be represented by a single line containing just
backslash-period (\.). An end-of-data marker is not necessary when reading
from a file, since the end of fil
On 10/27/2015 10:04 AM, Adrian Klaver wrote:
On 10/27/2015 08:44 AM, Jeff Janes wrote:
On Mon, Oct 26, 2015 at 2:45 PM, David Blomstrom
mailto:david.blomst...@gmail.com>> wrote:
I tried to import a CSV file into a PostgreSQL table using pgAdmin
III. I got an error message: "extra data a
On 10/27/2015 08:44 AM, Jeff Janes wrote:
On Mon, Oct 26, 2015 at 2:45 PM, David Blomstrom
mailto:david.blomst...@gmail.com>> wrote:
I tried to import a CSV file into a PostgreSQL table using pgAdmin
III. I got an error message: "extra data after last column."
All my spreadsheets h
On Mon, Oct 26, 2015 at 2:45 PM, David Blomstrom
wrote:
> I tried to import a CSV file into a PostgreSQL table using pgAdmin III. I
> got an error message: "extra data after last column."
>
>
> All my spreadsheets have an "end of data" column that has /r/n in each
> cell. When I import a CSV file
Op 27/10/2015 om 15:32:46 +0100, schreef David Steele:
> On 10/27/15 3:16 PM, Leo Baltus wrote:
> >postgresql-9.4.5
> >
> >When running pg_stop_backup() psql outputs on stderr:
> >
> >NOTICE: pg_stop_backup complete, all required WAL segments have been
> >archived
> >
> >--quiet does not seem to
postgresql-9.4.5
When running pg_stop_backup() psql outputs on stderr:
NOTICE: pg_stop_backup complete, all required WAL segments have been archived
--quiet does not seem to suppress it, what does?
I really hate to redirect stderr to /dev/null.
--
Leo Baltus, internetbeheerder
NPO ICT Intern
On 10/27/15 3:32 PM, David Steele wrote:
On 10/27/15 3:16 PM, Leo Baltus wrote:
postgresql-9.4.5
When running pg_stop_backup() psql outputs on stderr:
NOTICE: pg_stop_backup complete, all required WAL segments have been
archived
--quiet does not seem to suppress it, what does?
This should
postgresql-9.4.5
When running pg_stop_backup() psql outputs on stderr:
NOTICE: pg_stop_backup complete, all required WAL segments have been archived
--quiet does not seem to suppress it, what does?
I really hate to redirect stderr to /dev/null.
--
Leo Baltus, internetbeheerder
NPO ICT Intern
On 10/27/2015 07:16 AM, Leo Baltus wrote:
postgresql-9.4.5
When running pg_stop_backup() psql outputs on stderr:
NOTICE: pg_stop_backup complete, all required WAL segments have been archived
--quiet does not seem to suppress it, what does?
test=> set client_min_messages = 'warning';
SET
te
On 10/27/15 3:16 PM, Leo Baltus wrote:
postgresql-9.4.5
When running pg_stop_backup() psql outputs on stderr:
NOTICE: pg_stop_backup complete, all required WAL segments have been archived
--quiet does not seem to suppress it, what does?
This should work:
set client_min_messages='warning';
The only other option would be to redirect to a file.
EG:
psql -q --o some_file_to_send_output_to.log
On Tue, Oct 27, 2015 at 10:16 AM, Leo Baltus wrote:
> postgresql-9.4.5
>
> When running pg_stop_backup() psql outputs on stderr:
>
> NOTICE: pg_stop_backup complete, all required WAL segments
On 10/26/2015 03:28 PM, Leonardo wrote:
Hello all,
i'm looking for a way to insert a file into a table using available
binding for nodejs.
just for comparison, if i where using java on server the upload code
would be like this:
protected void doPost(HttpServletRequest request,
HttpServletRespo
On Monday, October 26, 2015, John R Pierce wrote:
> On 10/26/2015 7:44 PM, David G. Johnston wrote:
>
>> They both have their places. It is usually quite difficult to automate
>> and version control the manual work that goes into using command line
>> tools.
>>
>
> I hope you mean, its difficu
28 matches
Mail list logo
