I imagine pg_restore can execute the instructions on dump but don't
write on disk. just like David said: "tell me what is going to happen
but don't actually do it"
Regards.
On Wed, Aug 2, 2017 at 11:49 AM, Tom Lane wrote:
> Edmundo Robles writes:
>
I mean, to verify the integrity of backup i do:
gunzip -c backup_yesterday.gz | pg_restore -d my_database && echo
"backup_yesterday is OK"
but my_database's size, uncompresed, is too big more than 15G and
sometimes i have no space to restore it, so always i must declutter my
disk fi
Hi! i have many too long time queries, the oldest is almost 16 days,
so i tried to cancel and terminate with pg_cancel_backend and
pg_terminate_backend but queries is still running.
STIME ELAPSED ELAPSED %CPU PID COMMAND
jun27 15-23:05:46 1379146 0.3 29660 postgres: argos_admin bdka
Hi !
I have Postgresql 9.4, a partitionated table and i must change the type
of column.
The changes over a master table DDL are applied to the childs?
or must I change the inheritance to off and change it one by one? for
each child and master table.
what is the best way/practice
this issue was raised by timezone settings ...
On Wed, Feb 1, 2017 at 10:15 AM, Edmundo Robles
wrote:
> i just changed the jdbc, but still get the wrong values...
>
> On Wed, Feb 1, 2017 at 9:47 AM, Edmundo Robles
> wrote:
>
>> this issues could be raised by a incor
I have postgresql 9.4 and wrote a function get_ignition_time() to get
the first time when a car was ignition on and the last time when
ignition is off, those
time stamps are used in another function get_fuel_consumption() to get
the fuel consumption.
The issue is when:
1. I run ge
this issues could be raised by a incorrect jdbc? the jdbc used is
postrgresql-9.2-1002.jdbc4.jar and i have a postgresql 9.4
On Wed, Feb 1, 2017 at 9:35 AM, Edmundo Robles wrote:
>
> I have postgresql 9.4 and wrote a function get_ignition_time() to get
> the first time when a
i just changed the jdbc, but still get the wrong values...
On Wed, Feb 1, 2017 at 9:47 AM, Edmundo Robles wrote:
> this issues could be raised by a incorrect jdbc? the jdbc used is
> postrgresql-9.2-1002.jdbc4.jar and i have a postgresql 9.4
>
> On Wed, Feb 1, 2017 at 9:35
thanks for your comments, i will change the constraints from date to
timestamp with time zone, i hope this works :)
On Mon, Jan 23, 2017 at 7:48 PM, Tom Lane wrote:
> Adrian Klaver writes:
> > On 01/23/2017 05:14 PM, David G. Johnston wrote:
> >> To your example - testing in UTC is going to al
On Mon, Jan 23, 2017 at 6:02 PM, Adrian Klaver
wrote:
> On 01/23/2017 03:45 PM, Edmundo Robles wrote:
>
>> Hi!
>>
>> I have backed up a database with a 'UTC' timezone, but i can not to
>> restore it on a database with 'localtime' timezone.
&
Hi!
I have backed up a database with a 'UTC' timezone, but i can not to
restore it on a database with 'localtime' timezone.
I have a time constraints, the reason of the mistakes.
* First, I did: 'alter database set timezone='UTC'; 'but no restore
it...
* After I did change 'timezone
: argos_admin vacia
127.0.0.1(38634) SELECT waiting
root 29071 6468 0 11:56 pts/200:00:00 grep postgres
On Tue, Jan 10, 2017 at 11:56 AM, Edmundo Robles
wrote:
> how can i detect and cancel the process??
>
>
> --
>
>
--
how can i detect and cancel the process??
--
I have running Postgresql 9.4 and... if i have a table with following
configuration:
autovacuum_vacuum_scale_factor=0.0,
autovacuum_analyze_scale_factor=0.0,
autovacuum_vacuum_threshold=1000,
autovacuum_analyze_threshold=1000,
autovacuum_enabled=true
Why autovacuum is not started if the ta
Maybe visual paradigm could help you, you can reverse and generate the
database in postgresql.
On Thu, Dec 22, 2016 at 11:50 PM, Günce Kaya wrote:
> Hi All,
>
> I'm looking for an ER Data Modeller tool for postgresql. I use Navicat
> Premium for postgresql and the tool has a modeller but I woul
rtis to the new t2_child
On Thu, Dec 22, 2016 at 8:51 AM, Edmundo Robles
wrote:
> I want to do that because, I have a partitioned table (big_table) and
> others (t1,t2,t3,t4) have foreign keys reference to big_table and i
> had many trobules at insert data, reading the doc:
> &
) and foreign key constraints only apply to single
tables, not to their inheritance children. "
On Wed, Dec 21, 2016 at 4:58 PM, Tom Lane wrote:
> Edmundo Robles writes:
> > i need disable inheritance from many tables in a query like
> > "delete from pg_inherits w
Hi!
i need disable inheritance from many tables in a query like
"delete from pg_inherits where inhparent=20473" instead alter table ...
but is safe? which is the risk for database if i delete it?
I have a big,big table, this big table is referenced by another tables
by foreign keys.
I have a performance issues so i decide partition it by month ->
...,table_201610,table_201611,table_201612,...
after i have been created the partition tables i try to insert data but
foreign key constrai
Hi!
i have a simple question, if the master table have an index, must i
have create the same index in a child table?
what is the best practice for indexes in table partition ?
veral servers (multimaster configuration like
> https://wiki.postgresql.org/wiki/Bucardo)
>
>
>
> Ilya Kazakevich
>
>
>
> JetBrains
>
> http://www.jetbrains.com
>
> The Drive to Develop
>
>
>
> *From:* pgsql-general-ow...@postgresql.org [mailto
Hi!
I want find a software to 'enqueue' the client connections to database, so
if i reach the max limit the query must be holding in a queue until one
connection is released.
I have many devices (100+) saving their state to a database, each
minute, but the table is too large more than 13,0
don't worry. I still working in this copy, how can i do to insert
newlines to generate the copy dynamically and avoid the syntax error.
On Fri, Aug 12, 2016 at 11:11 AM, Adrian Klaver
wrote:
> On 08/12/2016 08:15 AM, Edmundo Robles wrote:
>
>> Adrian, your'e right
rrent have more than 13,000,000 records, plus
have many indexes, that the reason why is slow to insert That's why i
tried to use copy.
On Fri, Aug 12, 2016 at 9:43 AM, Adrian Klaver
wrote:
> On 08/12/2016 07:11 AM, Edmundo Robles wrote:
>
>> Hi!
>> I hope you could help m
Hi!
I hope you could help me...
I tried to generate the next copy instruction in a function:
copy tablefoo (id_foo, foo_name, foo_lastname, foo_age) FROM stdin
DELIMITER as '|' ;
12060157|John|Doe|33
\.
** The commands to generate the copy are:
CREATE OR REPLACE FUNCTION insert_tablefo
Hi!
How can i get the same behavior of psql -c "\\i './a_lot_of_sentences'" bd
user, using the libpq library???
i tried Pqexec(pgconn,"\\i './a_lot_of_sentences'") but didn't work. :(
--
SENSA Control Digital.
Ing. Edmundo Robles Lopez.
is a best way to tweak the memory consumed by postgres?
--
SENSA Control Digital.
Ing. Edmundo Robles Lopez.
Analista Programador.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi, i tried to compile postgres 8.3.13 but i got the next error:
Undefined first referenced
symbol in file
PQconnectionNeedsPassword pg_ctl.o
ERROR: Symbol referencing errors. No output written to pg_ctl
cc -b elf -O pg_ctl.o -L../..
why sometimes checkpoint is too slow
and how can i do to avoid that???
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
hi! i have postgresql 8.3.12 and i got the eror:
PANIC: ERRORDATA_STACK_SIZE exceeded
This happens after insert 1000 registers on a table every 1 minute
during 3 hours.
any idea, why this happened???
# -
# PostgreSQL configuration file
#
Hi !
i have the above error when i tried to insert a register, How can i
solve this issue???'
regards .
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 07/22/2010 05:39 PM, Scott Marlowe wrote:
> On Thu, Jul 22, 2010 at 3:24 PM, Edmundo Robles L.
> wrote:
>
>> Hi!
>> I have a problem with the max postgres connections on SCO
>> Openserver 5.0.7, so ...my boss decided to buy the SCO Openserver 6.0
>&
Hi!
I have a problem with the max postgres connections on SCO
Openserver 5.0.7, so ...my boss decided to buy the SCO Openserver 6.0
but this version comes in 2 editions: Starter and Enterprise.
If SCO 5.0.7 only allows 95 ( -3 used by superuser) connections to
postgres...
Do you kno
Hi!, maybe is a silly question but...
Exists some syntax standard to escape especial characters on querys???
i mean, the notation E'\\ to escape especial characters only works
in postgres (8.3.11) or this works on oracle, ms sql server too???
regards, eddie.
--
Sent via pgsql-general mai
Hi!
if a want the first 5,10,N tuples of a query (even without order)
i just have to do a:
select * from table limit 10;
but, What can i do to get the last 10 tuples ???
i try to do:
select * from table limit -10; :-D but that query return 0 tuples .
So, what is the right way to
Do you know if the pgpool list is down???, i sent many emails to the
pgpool list but since last week i can't receive any mail from pgpool
list ,
i checktheir web site too, but the last message are of june.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To m
does'nt exists.
well, thats all for the moment and i appreciate your time in reading this
mail!!!
See you.
--
SENSA Control Digital.
Ing. Edmundo Robles Lopez.
Analista Programador.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
in the psql prompt try this:
\! stty sane
Ing. Edmundo Robles Lopez.
Analista Programador.
--
-Original Message-
From: pgsql-general-ow...@postgresql.org on behalf of Juan Camilo Marín
Sent: Wed 5/13/2009 12:58 PM
To: Craig Ringer
Cc: pgsql-general@postgresql.org
Subject: Re
"Edmundo Robles L." writes:
> I have a problem with the number of connections on postgres 7.2.1,
-->egad ... the number of known bugs in that would curl your toes.
-->Think about an upgrade. Do more than just think about it.
yes, maybe the upgrade solve that proble
Hello there!
I have a problem with the number of connections on postgres 7.2.1, yeah
is a quite older :-)
but i have it running on SCO OpenServer 5.0.7 and tried to change
the number of connections above 100 but,
i only got 100 sometimes 101 but no more.
I changed the parameters li
40 matches
Mail list logo