> On May 11, 2017, at 10:40 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
>
> On 05/11/2017 07:32 AM, Vibhor Kumar wrote:
>>> On May 11, 2017, at 10:17 AM, Adrian Klaver <adrian.kla...@aklaver.com
>>> <mailto:adrian.kla...@aklaver
RPM install. You would probably have to
> change the port numbers, at least temporarily, while you do the migration.
> This way you could use the packaging system without resorting to work-arounds.
I don’t think Martin has to migrate database. He has installed PostgreSQL 9.6
using EDB one-click installer. I can see two options here:
1. Install PostgreSQL using RPM as mentioned by Adrian. Stop the PostgreSQL
using one click installer binaries and start using RPM binary. After that
Martin can install repmgr using RPM.
2. Compile repmgr with existing installation.
https://github.com/2ndQuadrant/repmgr <https://github.com/2ndQuadrant/repmgr>
Thanks & Regards,
Vibhor Kumar
Blogs:https://vibhorkumar.blog
, testname FROM my_foreigntbl) TO '/tmp/testlist_aid'
(DELIMITER ',');
I am curious to know, why do you want to execute COPY command through fdw, why
not run directly on server, which has table?
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Postgres Database Company
Blog:http
in database.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Postgres Database Company
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Jun 21, 2013, at 3:38 PM, Lonni J Friedman netll...@gmail.com wrote:
On Fri, Jun 21, 2013 at 11:17 AM, Vibhor Kumar
vibhor.ku...@enterprisedb.com wrote:
On Jun 21, 2013, at 2:05 PM, Lonni J Friedman netll...@gmail.com wrote:
On Fri, Jun 21, 2013 at 10:56 AM, Vibhor Kumar
vibhor.ku
)::timesta...
^
It failed.
Reason is: From postgreSQL 9.2 onwards, pg_stat_activity.procpid is renamed as
pg_stat_activity.pid.
http://www.postgresql.org/docs/9.2/interactive/release-9-2.html
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL
which you can use in CREATE TABLE command as given
below:
CREATE domain citext_char as CITEXT CHECK(length(value) = 3);
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Blog: http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general
files the new transactions and apply them
when call pg_stop_backup().
I must do it other way then :(
Thanks
If you are doing pg_start_backup(), taking snapshot and pg_stop_backup with
archived WAL file backups. Then its safe.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
='0010a3e4cc6cb8623c014f5bb95b5be1';
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Blog: http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
installing the contrib module you have to execute following command in
Database:
CREATE EXTENSION dblink;
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Blog: http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Blog: http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
log_statement parameter.
http://www.postgresql.org/docs/current/static/runtime-config-logging.html#GUC-LOG-STATEMENT
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Blog: http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general
.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Blog: http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to run some script to have it available ?
xslt_process function is part of xml2 contrib module. Execute following for xml2
CREATE EXTENSION xml2;
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Blog: http://vibhork.blogspot.com
--
Sent via pgsql
input
from shell command.
Something like given below:
psql -c COPY mytable to STDOUT|gzip /home/tgl/mytable.dump.gz
cat filename|psql -c COPY mytable from STDIN;
OR psql -c COPY mytable from STDIN; filename
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
On Jul 21, 2011, at 3:59 AM, Tatsuo Ishii wrote:
On Jul 20, 2011, at 18:11, Andrej andrej.gro...@gmail.com wrote:
Can anyone recommend PostgreSQL 9.0 High Performance by G. Smith?
Yes.
+1.
+1.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
to follow and some links too.
I think you would like to go through following thread:
http://archives.postgresql.org/pgsql-sql/2010-04/msg6.php
Presentation:
http://wiki.postgresql.org/images/9/91/Pguswest2008hnd.pdf
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise
On Jun 7, 2011, at 4:09 PM, AI Rumman wrote:
Is there any maximum size limit for a query string in Postgresql 9.0.1?
If yes, what is it ?.
track_activity_query_size parameter.
http://www.postgresql.org/docs/9.0/static/runtime-config-statistics.html
Thanks Regards,
Vibhor Kumar
EnterpriseDB
bad :(. I understood this question wrong.
Regards
Pavel Stehule
2011/6/7 Vibhor Kumar vibhor.ku...@enterprisedb.com:
On Jun 7, 2011, at 4:09 PM, AI Rumman wrote:
Is there any maximum size limit for a query string in Postgresql 9.0.1?
If yes, what
Please post the questions about xDB Replication on following link:
http://forums.enterprisedb.com/forums/show/3.page
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhorkumar.wordpress.com
--
Sent via pgsql
On May 17, 2011, at 3:17 AM, Gauthier, Dave wrote:
Is there a way to suppress the INSERT x x and DELETE y (etc...) messages
in psql?
psql -q
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Wordpress:http
On Apr 28, 2011, at 2:56 PM, Thomas Larsen Wessel wrote:
UPDATE foo SET bar = TO_VARCHAR( TO_FLOAT(bar) * 2); -- INCORRECT
If you are sure bar contains float value, then try following:
UPDATE foo SET bar = bar::float * 2;
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
On Apr 28, 2011, at 3:22 PM, Dmitriy Igrishin wrote:
NB: I am sure that OP is not sure :-) And since foo.bar is varchar,
it is better to use numeric instead of float :-)
Now, this make to ask question, why numeric? How its better than float?
Thanks Regards,
Vibhor Kumar
EnterpriseDB
have missed.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
/Streaming_Replication
Thanks Regards,
Vibhor
On Apr 22, 2011, at 11:08 AM, Tiruvenkatasamy Baskaran wrote:
Hi Vibhor Kumar,
Here is the configuration changes.
Changes made on Master DB
-
1. tar –xzvf postgresql-9.0.4.tar
2. cd postgresql-9.0.4
of PG Database
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
is not running and
not able to query table.
Please confirm if you have made Slave DB using PITR/Hot Backup of Master. Also,
please let me know the steps which you have followed.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
On Apr 21, 2011, at 4:23 PM, Tiruvenkatasamy Baskaran wrote:
Which version of postgresql supports replication on RHEL6?
RHEL version : 2.6.32-71.el6.x86_64
Why are you re-posting your question, if it has been answered?
Thanks Regards,
Vibhor Kumar
Blog:http://vibhork.blogspot.com
. However it has given
me what I needed. Online VACUUM FULL (for primary key table), Online CLUSTER.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql
about an alternative to pg_reorg on depesz' Blog:
http://www.depesz.com/index.php/2010/10/17/reduce-bloat-of-table-without-longexclusive-locks/
For huge bloats, mentioned Method is slower.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku
On Apr 11, 2011, at 11:56 PM, Willy-Bas Loos wrote:
My ON INSERT rule won't go off when I copy into it.
Is there a way to COPY into a RULE?
COPY Command does not respect rule on table, so please use trigger.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL
Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
;
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
with single comparison
operator (like = ) in condition clause.
Please share the query which is giving this error message
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general
[ Please don't overpost the list. Adding PG General List]
On Apr 5, 2011, at 3:30 AM, Ray Stell wrote:
On Tue, Apr 05, 2011 at 02:42:30AM +0530, Vibhor Kumar wrote:
On Apr 5, 2011, at 2:31 AM, Ray Stell wrote:
What does the results in col 'List of schemas Access privileges'
indicate
On Apr 5, 2011, at 6:07 PM, Ray Stell wrote:
On Tue, Apr 05, 2011 at 03:58:46PM +0530, Vibhor Kumar wrote:
Following are details:
postgres=UC/postgres+
[user] [privs] /[ ROLE who granted privs.
What's the logic for reporting the U priv twice?
If you are talking about following
)
* -- grant option for preceding privilege
/ -- role that granted this privilege
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list
role and trying to login as role. Create user and then try.
USER=ROLE+Login Privilege.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general
under /usr/local/ linked via enviromentab
le variables in .profile / config options ./configure.gnu -des -Duseshrplib
--prefix=/usr/local/perl5)
Any Error Message?
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http
Following link:
http://rpm.pbone.net/index.php3/stat/4/idpl/14282865/dir/opensuse/com/psqlODBC-08.03.0200-9.2.i586.rpm.html
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general
make install
If you are using one-click installer by EnterpriseDB then you can use
unattended mode of installer. Following is a link:
http://www.enterprisedb.com/docs/en/8.4/instguide/Postgres_Plus_Advanced_Server_Installation_Guide-15.htm#P889_74430
Thanks Regards,
Vibhor Kumar
EnterpriseDB
and restarting to bring up a new slave.
You can try repmgr developed by 2nd Quadrant. Link is given below:
http://projects.2ndQuadrant.com/repmgr
You can also try with pgpool failover feature:
http://pgpool.projects.postgresql.org/
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise
? What the the best way to manage the removal of old archive logs?
Its totally upto you which method you want to follow.
tar command gives an option of deleting of files, after archiving it
(--remove-files).
Thanks Regards,
Vibhor Kumar
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general
is same and Data Directory is
same, then \l should show all databases.
Please reconfirm the data directory and Version of PG.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql
A, if the there is any change happened Or Any session has evicted the
cached data.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general
||' where id = 1'
LOOP
return next rec.empno;
END LOOP;
return next rec.empno;
END;
$$ language plpgsql;
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent
QUERY EXECUTE 'SELECT content FROM ' || quote_ident(tablename);
END;
$$ LANGUAGE plpgsql;
To prevent from sql injection user can try with SQL Protect:
http://www.enterprisedb.com/docs/en/9.0/sqlprotect/Table%20of%20Contents.htm
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise
: Illegal Query: relations
Which stops user guessing relation.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
(
6,ARRAY[row('a', 'aa'), row('b',
'bb')]::mytype[] );
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
of that
http://www.postgresql.org/docs/8.4/static/sql-createtype.html
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
[ trigger_name | ALL | USER ]
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
,
u.first_name order by sum desc limit 3;
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
, u.first_name having
sum(m.completed 30 order by sum desc limit 3;
On Tue, Mar 15, 2011 at 10:43 PM, Vibhor Kumar
vibhor.ku...@enterprisedb.com wrote:
On Mar 16, 2011, at 3:03 AM, Alexander Farber wrote:
# select u.id, u.first_name, sum(m.completed)
from pref_users u, pref_match m
where
by...
^
Use having clause for aggrgate function,
group by col1, col2 having sum(col)
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via
before any
upgrade.
Can you explain, why are you upgrading to 9.1? Currently there is no Prduction
release of 9.1.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general
to_timestamp function. For more detail refer following documentation:
http://www.postgresql.org/docs/8.3/static/functions-formatting.html
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via
On Mar 9, 2011, at 9:56 AM, abcdef wrote:
I use postgresql in red hat linux .
I want to know how I can find out all the procedure stored in the database .
Any SQL command to do it ???
pg_catalog.pg_proc can be use to find all the functions.
Thanks Regards,
Vibhor Kumar
EnterpriseDB
in dos script.
set PGPASSWORD=passowrd
Or you can use pgpass.conf file option.
3. Is there a way of running the pg_dump with a user that doesn't have a
password?
For that user, you have to mention trust with hostname in pg_hba.conf
Thanks Regards,
Vibhor Kumar
vibhor@gmail.com
Blog:http
cursor handling):
sql = select * from || :tablename || where...
for select :sql
...
Can I do same thing in PGSQL too?
Thanks:
dd
You can use EXECUTE dynamic Command of plgpsql:
http://www.postgresql.org/docs/8.4/static/plpgsql-statements.html
Thanks Regards,
Vibhor Kumar
-c 'COPY tablename to STDOUT;' dbname|psql -c 'COPY tablename from STDIN;'
dbname
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general
. Import data using COPY Command.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
. -- This will give zero Bloats.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
, refobjid,
deptype FROM pg_depend WHERE deptype != 'p' ORDER BY 1,2
pg_dump: *** aborted because of error
reindexdb -s database name
will resolve the issue.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http
+ package or something? You should
probably contact them via their support channels.
GRANT all on function nvl to public would help.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via
to add explicit type casts.
Error Message is only saying nvl(integer,integer) does not exists.
Please check offload database is having function nvl and then, grant all on
that function.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku
, if function
returning single value. You can use EXECUTE 'SELECT '||$1||'(y)' into x;
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general
site::pg_catalog.text OPERATOR(pg_catalog.=) $1::pg_catalog.text AND
cp::pg_catalog.text OPERATOR(pg_catalog.=) $2::pg_catalog.text FOR SHARE OF
x
Try to give SELECT privileges to user on table public.out2cp
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
vibhor.ku...@enterprisedb.com
/backup.html
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Regards,
Vibhor Kumar
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
base backup (Restoring without PITR) ?
Thanks Regards,
Vibhor Kumar
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
, but the pg documentation indicates this should be
OK and we saw no cause for concern in the pg logs.
What options have you used for shutting down?
Thanks Regards,
Vibhor Kumar
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql
are in template1 database.
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Cell: +91-932-568-2279
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
:
http://www.postgresql.org/docs/8.4/static/intarray.html
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Cell: +91-932-568-2279
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general
-restore.
Using Postgres 8.4.X.
I assume slony replication is an option.
Right! Replication would help. You can also try Bucardo.
What about some sort of wal log shipping replication?
WAL Log shipping won't help.
Thanks Regards,
Vibhor Kumar
--
Sent via pgsql-general mailing list
row_number() over(order by stamp) as id, stamp
from test;
Thanks Regards,
Vibhor Kumar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Feb 21, 2011, at 1:39 PM, Yan Cheng CHEOK wrote:
INSERT INTO backup_table SELECT * FROM unit_11 WHERE status = 1;
You can try something like,
INSERT INTO backup_table select unit_id, 99, status, value from unit_11 where
status=1;
Thanks Regards,
Vibhor Kumar
EnterpriseDB Corporation
tried using -t servers, and I get :
pg_dump: No matching tables were found
It should not. Try schemaname.tablename with switch -t.
Thanks Regards,
Vibhor Kumar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
can use proper where clause as given below:
CREATE INDEX indexname on tablename(columname) where condition;
example:
create index directed_graph_idx on directed_graph(node_from) where node_from in
('A','B');
Thanks Regards,
Vibhor Kumar
vibhor.ku...@enterprisedb.com
Blog:http
;
begin
t:='COMMENT ON TABLE TEST_COPY IS '||||'TEST WITH '||current_date||;
execute t;
end;
$$ language plpgsql;
Thanks Regards,
Vibhor Kumar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
On Sep 25, 2010, at 3:20 PM, Andre Lopes wrote:
Hi,
I need to generate the dump of a PostgreSQL database only with the data with
INSERT's. It is possible to do this?
Best Regards,
Use switch -a and --insert. For more information you can use pg_dump --help
Thanks Regards,
Vibhor
in the packages.
Yes, you are right. pg_filedump is not part of PG Source. Its a separate
module, which needs to be compile.
Thanks Regards,
Vibhor Kumar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
On Aug 12, 2010, at 2:43 PM, Peter Geoghegan wrote:
Hello,
I would like to set up pgAgent on windows. I'm using the EDB 8.4.4
package. I know that it is bad practice to put the password directly
in the conninfo string, so I've avoided that. I want to use pgpass
authentication, per the
On Aug 9, 2010, at 11:40 AM, tuanhoanganh wrote:
What is the name of DW in --type=DW
Sorry for my English.
DW: Data Warehouse
Tuan Hoang Anh
On Mon, Aug 9, 2010 at 6:21 PM, Amitabh Kant amitabhk...@gmail.com wrote:
2010/8/9 Sim Zacks s...@compulab.co.il
I just found out about
Sign up now.
http://education.in.msn.com/
You can use Crontab (linux)/Schedule Jobs(Windows).
With this if you want then your can use pgagent for scheduling Jobs.
For more information on pgagent, please refer following link:
http://www.pgadmin.org/docs/1.4/pgagent.html
--
Thanks Regards,
Vibhor
.
--
Thanks Regards,
Vibhor Kumar.
EnterpriseDB Corporation
The Enterprise Postgres Company
Office: 732-331-1300 Ext-2022
Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com
Follow us on Twitter: http://www.twitter.com/enterprisedb
--
Sent via pgsql-general mailing list
not exist
Try with reset_query_list= 'ABORT; DISCARD ALL'
--
Thanks Regards,
Vibhor Kumar.
EnterpriseDB Corporation
The Enterprise Postgres Company
Office: 732-331-1300 Ext-2022
Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com
Follow us on Twitter: http
% -d %database% -p %port% --file File.sql xx
--
Thanks Regards,
Vibhor Kumar.
Senior System Engineer.
EnterpriseDB Corporation
The Enterprise Postgres Company
Office: 732-331-1300 Ext-2022
Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com
Follow us on Twitter: http
/home/edb/AS83R2/build/AS83R2/edb-postgres/src/include'
LIBS = -lpgport -lmemcached -lxslt -lxml2 -lpam -lssl -lcrypto -lkrb5
-lz -ledit -ltermcap -lcrypt -ldl -lm
--
Thanks Regards,
Vibhor Kumar.
EnterpriseDB Corporation
The Enterprise Postgres Company
Office: 732-331-1300 Ext-2022
Website
/home/edb/AS83R2/build/AS83R2/edb-postgres/src/include'
LIBS = -lpgport -lmemcached -lxslt -lxml2 -lpam -lssl -lcrypto -lkrb5
-lz -ledit -ltermcap -lcrypt -ldl -lm
Thanks Regards,
Vibhor Kumar
EnterpriseDB Co.
ewall/antivirus software and restart
the PostgreSQL.
Following is a thread, which has good discussion on it:
http://www.mail-archive.com/pgsql-general@postgresql.org/msg132613.html
--
Thanks Regards,
Vibhor Kumar.
Hello,
Can any one help me if oracle like any user_source table is there in postgre
8.4 (in pg_catalog or information_schema).
Actually we migrated code from Oracle to Postgre. Now i want to search in how
many places( i.e. in functions ) we have used a particular syntax( e.g.
more exists in C:\Windows\System32. So, please set the path in PATH
Environment Variable. and then try.
My Computer (Right Click) - Properties - then go to Advanced tab -
Environment Variable - set the path.
Thanks Regards,
Vibhor Kumar
www.enterprisedb.com
raghu ram wrote:
Hi All,
Can
Hi Eugenio,
Use the following command to know about the locale.
pg_controldata Data Directory
For more information, please follow the link given below:
http://www.postgresql.org/docs/8.3/static/app-pgcontroldata.html
Thanks Regards,
Vibhor Kumar
www.enteprisedb.com
Stefan Kaltenbrunner wrote
the command:
http://www.postgresql.org/docs/8.1/static/app-pgcontroldata.html
Thanks Regards,
Vibhor Kumar
www.enterprisedb.com
Vibhor Kumar wrote:
Hi Eugenio,
Use the following command to know about the locale.
pg_controldata Data Directory
For more information, please follow the link given
,
Vibhor Kumar
www.enterprisedb.com
Mauro Bertoli wrote:
Hi all,
is possible in PostgreSQL to create query between multidatabase like Sql Server
2005?
An example:
SELECT
db1.a.id FROM db1.a
UNION
db2.b.id FROM db2.b
Where db1 is a database and db2 is another database. a is a table in database
96 matches
Mail list logo