Hi Ben,
Are you able to post these scripts?
On 2013-08-07 19:01, Adrian Klaver wrote:
On 08/07/2013 08:53 AM, Condor wrote:
Hello,
sorry for dumb question, did any one can tell me how the hell I can
remove clear screen after finish the sql query from console ?
This probably have some idea, but for me look like very ... not good
idea. Whe
I think you mean PAGER, not PAPER.
I usually do this:
PAGER=more psql
This will set it for the connection, and it lets me use less as a pager by
default elsewhere. You might also see what you can do to set it locally if
you want to change it for everything.
>
> Cheers,
> Hristo S.
>
> --
>>
On 7 August 2013 18:01, Adrian Klaver wrote:
> On 08/07/2013 08:53 AM, Condor wrote:
> http://www.postgresql.org/docs/9.2/interactive/app-psql.html
>
> pager
> Controls use of a pager program for query and psql help output. If the
> environment variable PAGER is set, the output is piped to the sp
On Thu, Aug 08, 2013 at 12:01:17PM +1000, Victor Hooi wrote:
> I'm just wondering if this is still the case?
Yes. Order by random() is and, most likely, will be slow. Not sure if
there is any engine that could make it fast.
> I just ran those benchmarks on my system (Postgres 9.2.4), and using OR
Hi,
I am going to sync slave with my master which is almost 500 G. I am not
using archive directory instead of I am using wal files for streaming. As
it may take almost 3 hours, I am thinking of setting up 400 for
wal_keep_segments where I have enough space available.
Without the space issue, cou
no problem if you have enough space. we have set it to 4096 one year
ago,everything is OK.
jov
在 2013-8-8 下午9:26，"AI Rumman" 写道：
> Hi,
>
> I am going to sync slave with my master which is almost 500 G. I am not
> using archive directory instead of I am using wal files for streaming. As
> it may t
On 08/08/2013 12:09 AM, Condor wrote:
On 2013-08-07 19:01, Adrian Klaver wrote:
On 08/07/2013 08:53 AM, Condor wrote:
Thank you,
last question: How I can find where is set this ENV ?
because:
I can't see this variable PAPER but yes, \pset paper work for connection.
If you don't wan
Hi,
I am trying some restore tools, can you advise how to find the latest
transaction ID in PostgreSQL and the transaction ID at a particular
"Point-In-Time"?
regards
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgr
> From: "ascot.m...@gmail.com"
> To: PostgreSQL general
> Cc: ascot.m...@gmail.com
> Sent: Thursday, 8 August 2013, 14:52
> Subject: [GENERAL] How to find transaction ID
>
> Hi,
>
> I am trying some restore tools, can you advise how to find the latest
> transaction ID in PostgreSQL and the
Hello to everybody,
I started to upload (via phpPgAdmin) to a local server a huge file (20GB) in
order to fill up a database.
The uploding completed and the transactions started. But unfortunately, my
browser crashed/freezed in the middle of the transactions.
I wanted to know, given that the uplo
On 08/08/2013 07:33 AM, dafNi zaf wrote:
Hello to everybody,
I started to upload (via phpPgAdmin) to a local server a huge file (20GB) in
order to fill up a database.
The uploding completed and the transactions started. But unfortunately, my
browser crashed/freezed in the middle of the transacti
> From: Glyn Astill
> To: "ascot.m...@gmail.com" ; PostgreSQL general
>
> Cc:
> Sent: Thursday, 8 August 2013, 15:20
> Subject: Re: [GENERAL] How to find transaction ID
>
>
>
>> From: "ascot.m...@gmail.com"
>> To: PostgreSQL general
>> Cc: ascot.m...@gmail.com
>> Sent: Thursday, 8 Au
On 8 August 2013 16:33, dafNi zaf wrote:
>
> Hello to everybody,
>
> I started to upload (via phpPgAdmin) to a local server a huge file (20GB)
> in
> order to fill up a database.
> The uploding completed and the transactions started. But unfortunately, my
> browser crashed/freezed in the middle o
dafNi wrote
> Should I assume that the transactions keep running?
Never assume...or at least try and verify those assumptions when possible.
To verify this assumption:
Connect to the DB directly as a super-user and run this (or something
similar):
SELECT procpid, current_query, client_addr, xac
2013/8/8 dafNi zaf :
> Hello to everybody,
>
> I started to upload (via phpPgAdmin) to a local server a huge file (20GB) in
> order to fill up a database.
20GB is a lot to be uploading from a browser, even in this day and age.
Is the web server configured to accept uploads of that size?
--
Sen
i execute it periodically and sometimes there is a transaction and other
times it's idle:
INSERT INTO traces VALUES (.)
or
in transaction
So it's still running.. even thought there is some idle time.
Thank you very much!
On Thu, Aug 8, 2013 at 5:46 PM, David Johnston wrote:
> dafNi w
its a huge file with such queries:
BEGIN;
INSERT INTO traces VALUES (.);
.
.
.
COMMIT;
Anyway, I managed to see that the transactions still occure like David
Johnston sugested. And luckily the browser is alive now after one hour that
it had been freezed...
thank you very much for the reply
yes, I altered the php.ini file in /etc/php5/apache2/ directory in order to
accept huge files.
The uploading has been completed and the transactions started.
I can now see the transactions using either: ps aux | grep postgres (via
command line)
or the solution David Johnston sugested.
Thank you
On Thu, Aug 8, 2013 at 6:23 AM, AI Rumman wrote:
> Hi,
>
> I am going to sync slave with my master which is almost 500 G. I am not
> using archive directory instead of I am using wal files for streaming. As
> it may take almost 3 hours, I am thinking of setting up 400 for
> wal_keep_segments wher
Yeah, I already set it like that and it works.
Thanks.
On Thu, Aug 8, 2013 at 11:59 AM, bricklen wrote:
> On Thu, Aug 8, 2013 at 6:23 AM, AI Rumman wrote:
>
>> Hi,
>>
>> I am going to sync slave with my master which is almost 500 G. I am not
>> using archive directory instead of I am using wal
Vishalakshi Navaneethakrishnan wrote:
> We have one production database server , having 6 DBs, Postgres
> 9.2.1 version.
There were some fixes for autovacuum problems in 9.2.3. Some other
fixes will be coming when 9.2.5 is released. Many of your problems
are likely to go away by staying up-to-
Guys i am using postgresql 9.2. How can i check if a particular table has
auto vacuum disabled manually or not. Which system catalog can get me this
information?
Thanks
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Prabhjot Sheena
Sent: Thursday, August 08, 2013 2:36 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] system catalog to check if auto vacuum is disabled for a
particular table
Guys i am using
Thanks Sergey,
This is going to help for sure. I'll also look at the url. What I've been
trying to understand is when python runtime is invoked during the function
execution (lifecycle?) . Maybe looking at plpython's source may help get an
understanding of that.
Regards
Seref
On Thu, Aug 8, 201
Hi all,
I have a database that uses the ltree extension. I typically create a new
database like so (as a normal user), using my script file:
CREATE DATABASE mydb WITH TEMPLATE template0 ENCODING 'UTF8';
And then su to postgres, login and install the ltree extension on mydb.
Then I logout of my
Don Parris wrote on 08.08.2013 23:13:
And to be able to run it from the Bash prompt (as securely as possible).
I thought I could add the commands and run the create script by doing:
sudo -u postgres psql -U user -W -d mydb --file=/home/user/dev/mydb_create.sql
I thought that, running my scrip
On 08/08/2013 03:13 PM, Don Parris wrote:
Hi all,
I have a database that uses the ltree extension. I typically create a
new database like so (as a normal user), using my script file:
CREATE DATABASE mydb WITH TEMPLATE template0 ENCODING 'UTF8';
And then su to postgres, login and install the
Linux Mint (from Ubuntu) version 9.1.
Postgres will no longer start, but I cannot find out why.
Command line:
$ /usr/lib/postgresql/9.1/bin/pg_ctl start -D /home/postgresql/9.1/main -l
/var/log/postgresql/postgresql-9.1-main.log -s -w -o '-c
config_file="/etc/postgresql/9.1/main/postgresql.conf"'
On 08/08/2013 03:02 PM, Oliver Elphick wrote:
Linux Mint (from Ubuntu) version 9.1.
Postgres will no longer start, but I cannot find out why.
So anything happen between the last time it started and now?:
Upgrade of Postgres?
Upgrade of Mint?
Something else?
Command line:
$ /usr/lib/postgre
On 08/08/2013 03:17 PM, Oliver Elphick wrote:
I tried to change the listen_addresses line in postgresql.conf, by
adding an IPv6 address. On meeting problems I tried changing it back.
What problems?
Have you run ps to see if there is another instance of Postgres running?
Currently it says:
On 8/8/2013 2:13 PM, Don Parris wrote:
I thought I could add the commands and run the create script by doing:
sudo -u postgres psql -U user -W -d mydb
--file=/home/user/dev/mydb_create.sql
I thought that, running my script as the superuser, it would have the
privileges necessary to install th
On Thu, Aug 8, 2013 at 5:44 PM, Thomas Kellerer wrote:
> Don Parris wrote on 08.08.2013 23:13:
>
> And to be able to run it from the Bash prompt (as securely as possible).
>>
>> I thought I could add the commands and run the create script by doing:
>> sudo -u postgres psql -U user -W -d mydb --f
On Thu, Aug 8, 2013 at 5:45 PM, Rob Sargent wrote:
> On 08/08/2013 03:13 PM, Don Parris wrote:
>
>Hi all,
>
> I have a database that uses the ltree extension. I typically create a
> new database like so (as a normal user), using my script file:
>
> CREATE DATABASE mydb WITH TEMPLATE templa
On Thu, Aug 8, 2013 at 6:30 PM, John R Pierce wrote:
> On 8/8/2013 2:13 PM, Don Parris wrote:
>
>> I thought I could add the commands and run the create script by doing:
>> sudo -u postgres psql -U user -W -d mydb --file=/home/user/dev/mydb_**
>> create.sql
>>
>> I thought that, running my script
To start with, it worked but the pg_hba.conf entry appeared to be wrong. I
tried changing that and then the current problem started. I tried
"listen_addresses = '*'"; then back to just 'localhost'.
Since I have maximum logging enabled, I don't think it is getting as far as
reading the configurat
On 08/08/2013 04:02 PM, Oliver Elphick wrote:
To start with, it worked but the pg_hba.conf entry appeared to be wrong.
I tried changing that and then the current problem started. I tried
"listen_addresses = '*'"; then back to just 'localhost'.
Since I have maximum logging enabled, I don't thi
On Mon, Jul 15, 2013 at 01:34:01PM +, Baldur Þór Emilsson wrote:
> Thank you all for your responses. I'm aware of xlogdump but I'm afraid it does
> not help me with readign the data in the WAL. It is mainly "for debugging or
> educational purposes" (citing the docs) and it outputs a lot of info
On Thu, Aug 8, 2013 at 11:18 AM, Kevin Grittner wrote:
> There were some fixes for autovacuum problems in 9.2.3. Some other
> fixes will be coming when 9.2.5 is released. Many of your problems
> are likely to go away by staying up-to-date on minor releases.
>
> By setting this so high, you are i
I'm going through all my usual steps for setting up streaming replication
on a new pair of servers. Modify configs as appropriate, rsync data from
master to slave, etc. I have this all automated with chef, and it has been
pretty bulletproof for awhile. However, today, I ran into this when
starting
On Fri, Aug 9, 2013 at 8:55 AM, Quentin Hartman
wrote:
> 2013-08-08 23:47:30 GMT LOG: WAL file is from different database system
> 2013-08-08 23:47:30 GMT DETAIL: WAL file database system identifier is
> 5909892614333033983, pg_control database system identifier is
> 5909892824786287231.
It look
Don Parris writes:
> When I try a simple psql -U postgres -W - just to initiate the psql
> session, I get:
> psql: FATAL: Peer authentication failed for user "postgres"
> It's like my regular user cannot connect as the postgres user.
You're right, it can't, if you've selected peer authenticatio
On Wed, Aug 7, 2013 at 7:01 PM, Victor Hooi wrote:
> also seems to suggest that using ORDER BY RANDOM() will perform poorly on
> Postgres.
>
> I'm just wondering if this is still the case?
>
> I just ran those benchmarks on my system (Postgres 9.2.4), and using ORDERY
> BY RANDOM did not seem subs
Oliver Elphick writes:
> Linux Mint (from Ubuntu) version 9.1.
> Postgres will no longer start, but I cannot find out why.
> Command line:
> $ /usr/lib/postgresql/9.1/bin/pg_ctl start -D /home/postgresql/9.1/main -l
> /var/log/postgresql/postgresql-9.1-main.log -s -w -o '-c
> config_file="/etc/po
On 9 August 2013 01:02, Oliver Elphick wrote:
Since I have maximum logging enabled, I don't think it is getting
as far as reading the configuration files - that is not mentioned
in the log.
I regularly run into problems when some editor adds a UTF-8 BOM to
pg_hba.conf or postgres
Hi All,
select * from pg_database where datname = 'template0';
-[ RECORD 1 ]-+
datname | template0
datdba| 10
encoding | 6
datcollate| en_US.UTF-8
datctype | en_US.UTF-8
datistemplate | t
datallowconn | f
datconnlimit | -1
datlastsy
On Thu, Aug 8, 2013 at 10:59 PM, Vishalakshi Navaneethakrishnan
wrote:
> Now the problem is autovacuum.. why it was invoked and increased the load?
> How to avoid this?
Upgrade to the latest minor version 9.2.4 first.
--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA
http://www.li
47 matches
Mail list logo
