, Oct 11, 2013 at 7:03 PM, Sergey Konoplev gray...@gmail.com wrote:
On Fri, Oct 11, 2013 at 10:08 AM, akp geek akpg...@gmail.com wrote:
We have 4 applications ( 2 transactional , 2 ( transactional + reporting
))
on postgres 32 bit 9.0.4
Some of the queries are extreemly taking time ( 10
, 63G total swap, 63G free swap
Regards
On Sat, Oct 12, 2013 at 7:43 AM, Michael Paquier
michael.paqu...@gmail.comwrote:
On Sat, Oct 12, 2013 at 12:56 AM, akp geek akpg...@gmail.com wrote:
We have been running 4 of our applications on 9.0.4, which we are
planning
to update the database
thank you all. We will upgrade to 64bit postgres 9.2.5 and take all your
suggestions for that. Mean while will run the pg_reorg or pg_repack to
take the bloat of the DB. Also pg_repack not installing on the solaris . I
will try pg_reorg.
Regards
On Sun, Oct 13, 2013 at 4:58 PM, John R Pierce
thanks for the advice..
Regards
On Sun, Oct 13, 2013 at 6:10 PM, Sergey Konoplev gray...@gmail.com wrote:
On Sun, Oct 13, 2013 at 2:40 PM, akp geek akpg...@gmail.com wrote:
thank you all. We will upgrade to 64bit postgres 9.2.5 and take all your
suggestions for that. Mean while will run
We have 4 applications ( 2 transactional , 2 ( transactional + reporting ))
on postgres 32 bit 9.0.4
Some of the queries are extreemly taking time ( 10 seconds). I can the
explain for that also.
I just want to get your thoughts on the conf file values we have are good.
Really appreciate your
Thanks for all suggestions. based on the constraints I had with network, I
could able to set up the warm stand by. I am seeing the following log file
I don't know to how to handle.
2013-10-03 17:52:00 GMT [27636]: [457-1] user=,db=LOG: restored log file
000101F60003 from archive
it is a firewall issue. they can't open the port that we requested it.
so as you mentioned tunnel to the primary via tunnel. will give that a try
regards
On Mon, Sep 30, 2013 at 11:10 PM, Chris Travers chris.trav...@gmail.comwrote:
On Mon, Sep 30, 2013 at 7:14 PM, akp geek akpg
the
files from master ( HOT STAND BY ).. master has trusted connection(ssh )
with slave.
Thanks a lot for the help.
On Tue, Oct 1, 2013 at 10:14 AM, akp geek akpg...@gmail.com wrote:
it is a firewall issue. they can't open the port that we requested it.
so as you mentioned tunnel
-line: line 0: Bad configuration option: ExitOnForwardFailure
command-line: line 0: Bad configuration option: ExitOnForwardFailure
Regards
On Tue, Oct 1, 2013 at 6:46 PM, Sergey Konoplev gray...@gmail.com wrote:
On Tue, Oct 1, 2013 at 2:03 PM, akp geek akpg...@gmail.com wrote:
One more thing
Hi all -
Currently we have set up one master one slave , which working
fine. Now we need to replicate to an other slave. The problem we have ,
the port that we use on primary can not be reached from the new slave. We
can't the change the primary port also, because many applications
Hi All -
We have been running postgres 9.0.2 since October. Streaming also
in place. Working flawless. yesterday suddenly the replication stopped.
When I look at the log file. This is what I have for the last 2 lines and
that's it. I don't see any discrepancies. Can you please help ?
Hi All -
I have created a dump of a big table into 5 split files. What is the
procedure to restore them using pg_dump.
I am getting the following error
pg_restore: [custom archiver] could not read from input file: end of file
pg_restore: *** aborted because of error
Appreciate your help.
-general-ow...@postgresql.org] *On Behalf Of *akp geek
*Sent:* Monday, April 22, 2013 3:36 PM
*To:* pgsql-general
*Subject:* [GENERAL] pg_restore from split files
** **
Hi All -
** **
I have created a dump of a big table into 5 split files. What is the
procedure to restore
It works ... combine them again. Thank you all
Regards
On Mon, Apr 22, 2013 at 3:57 PM, Steven Schlansker ste...@likeness.comwrote:
On Apr 22, 2013, at 12:47 PM, akp geek akpg...@gmail.com wrote:
pg_dump dbname -n schemaname -t table_name -Fc | split -b 500m -t
table.dump
Since
Hi all -
I am in desperate need of your help. The replication/streaming
stopped working on March5th. I followed the following procedure to restart
the streaming. After running it for couple of hours , the database is
crashing on the slave. This is on our production server. Thanks for
transpiring?
On Sat, Mar 9, 2013 at 6:51 AM, akp geek akpg...@gmail.com wrote:
Hi all -
I am in desperate need of your help. The replication/streaming
stopped working on March5th. I followed the following procedure to
restart
the streaming. After running it for couple of hours
:
On Sat, Mar 9, 2013 at 1:51 PM, akp geek akpg...@gmail.com wrote:
thank you. As you mentioned, I understood that I am starting the
streaming
scratch which is not what I wanted to do.
Here is what I am planning to .
Our replication process was down since March5th.
1. Is it Ok
case 03/05 ) . This is where I got confused.
Again thanks a lot. Now we will definitely upgrade
Regards
On Sat, Mar 9, 2013 at 7:11 PM, Lonni J Friedman netll...@gmail.com wrote:
On Sat, Mar 9, 2013 at 4:05 PM, akp geek akpg...@gmail.com wrote:
Appreciate your findings. taking your points
of
the replciation. so that I can be little proactive
Regards
On Thu, Mar 7, 2013 at 9:25 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Thu, Mar 7, 2013 at 5:28 PM, akp geek akpg...@gmail.com wrote:
Hi all -
Recently made change on our primary database
These have worked very reliably for many months.
-John
On Fri, Mar 8, 2013 at 11:53 AM, akp geek akpg...@gmail.com wrote:
I got it fixed.
What I did was
$ psql -c SELECT pg_start_backup('label', true)
$ rsync -a ${PGDATA}/ standby:/srv/pgsql/standby/ --exclude postmaster.pid
$ psql -c
the data directory on to the slave
3. stopped the base backup on master
4. started the db on slave
Appreciate your help.
Regards
On Sat, Mar 9, 2013 at 12:52 AM, akp geek akpg...@gmail.com wrote:
Thanks a lot. I started the replication. It became very slow. It is taking
long time to sync
Hi all -
Recently made change on our primary database
default_text_search_config = 'pg_catalog.simple' . After that
the replication is stopped. Can you please help me ? how to fix the issue.
I am sure I made the change on the slave also.
How can I start the
Hi all -
We are using to_tsquery and to_tsvector quite a bit. I have
noticed that it is not searching for Y. is there some settings I have
to do make sure when search for string that has Y to return the correct
results?
Thanks for the help
Regards
thank you so much for all the inputs.. One final question is , Do we have
to stop the database when we create the base backup?
Regards
On Wed, Dec 5, 2012 at 4:45 PM, Tom Lane t...@sss.pgh.pa.us wrote:
akp geek akpg...@gmail.com writes:
thank you all. There is a mistake I did then. I
Hi all -
We have postgres 9.0.4 since an year. Replication also set up and
works fine. On the master. The wal files are growing and it's almost gone
to 90% of the disk. How can I handle the situation. Can I delete the old
files. Please advice
Regards
Thanks for the help
WAL archives is growing, not the files in pg_xlog.
Regards
On Wed, Dec 5, 2012 at 3:38 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
akp geek wrote:
We have postgres 9.0.4 since an year. Replication also set up and works
fine.
On the master. The wal files are growing and it's almost
thank you all. There is a mistake I did then. I created a base backup when
I started the DB , that was exactly an year ago. I need to do that again
and then delete the old files.
Regards
On Wed, Dec 5, 2012 at 4:25 PM, Tom Lane t...@sss.pgh.pa.us wrote:
akp geek akpg...@gmail.com writes
Thanks all. We will stick with CVS then. Thanks again
On Tue, Feb 28, 2012 at 3:36 PM, Greg Williamson gwilliamso...@yahoo.comwrote:
akp geek asked:
Would like to know if any one of you have used CVS or some other
version controlling tools to version the postgres code? Any
Hi all -
Would like to know if any one of you have used CVS or some other
version controlling tools to version the postgres code? Any
recommendations? Appreciate your help
Regards
...@gmail.com
wrote:
On Mon, Jan 9, 2012 at 12:37 PM, akp geek akpg...@gmail.com wrote:
I have statement_timeout as commented in the postgresql.conf. I just
checked it..
statement timeout, like so many things, can be set per user or per
database. Connect as the backup use and issue
Hi All -
During the backup of the database, we experience timeout on
queries. any one has experienced the same? Is there any parameters in the
postgressql.conf that I have to pay attention to? Can you please help
Regards
I am using pg_dump to back up each schema in the database and there 6
schemas in the database.
thanks
On Mon, Jan 9, 2012 at 1:26 PM, Jerry Sievers gsiever...@comcast.netwrote:
akp geek akpg...@gmail.com writes:
Hi All -
? ? ? ? ? ? ? ? During the backup of the database, we experience
I have statement_timeout as commented in the postgresql.conf. I just
checked it..
Thanks
On Mon, Jan 9, 2012 at 2:31 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Mon, Jan 9, 2012 at 11:05 AM, akp geek akpg...@gmail.com wrote:
Hi All -
During the backup
I have the replication set up and I am running the pg_dump against the
master
Thanks
On Mon, Jan 9, 2012 at 2:33 PM, Adrian Klaver adrian.kla...@gmail.comwrote:
On Monday, January 09, 2012 11:16:46 am akp geek wrote:
I am using pg_dump to back up each schema in the database and there 6
at 5:35 PM, Chris Travers chris.trav...@gmail.comwrote:
On Tue, Dec 20, 2011 at 11:53 AM, akp geek akpg...@gmail.com wrote:
Hi All -
Is there way that we write the logs specific to only one
user
in postgres? What I want to do is, Write the log files that are coming
from
Hi All -
Is there way that we write the logs specific to only one
user in postgres? What I want to do is, Write the log files that are coming
from one user or block the log entry for a pariticular user. Can you
please help? We have postgres 9.0.4
Regards
Thanks , it worked
On Wed, Dec 7, 2011 at 12:01 PM, Ben Chobot be...@silentmedia.com wrote:
On Dec 7, 2011, at 8:45 AM, akp geek wrote:
Small Clarification. I have gone through the documentation. I did not
find any thing related to start ans stop replication after the replication
is setup
Hi All -
Need some help. We have been using postgres 9.0.4 for our
production environment for some time. Today we are going to restart the
Solaris servers.
We have streaming on . My question is how to handle the streaming
when we start the database on the servers.
Can
please comment?
Regards
-- Forwarded message --
From: akp geek akpg...@gmail.com
Date: Wed, Dec 7, 2011 at 9:03 AM
Subject: postgres 9.0.4 Streaming relate question ..
To: pgsql-general pgsql-general@postgresql.org
Hi All -
Need some help. We have been using postgres 9.0.4
Hi all -
I am trying to run the psql command the following way and
it's failing . Can you please help?
psql -d mydb -c 'update tb_user set accountstatus='A'
where userid=123'
*ERROR: column a does not exist*
*LINE 1: ...date tb_user accountstatus=A*
*
*
Thanks
Thanks a lot .. Got it
On Wed, Sep 21, 2011 at 11:01 AM, patrick keshishian pkesh...@gmail.comwrote:
On Wed, Sep 21, 2011 at 7:54 AM, akp geek akpg...@gmail.com wrote:
Hi all -
I am trying to run the psql command the following way and
it's failing . Can you please help
Hi all -
We are using 9.0.4 on solaris. We set up the streaming. it is
running fine. The files keep accumulating in archive directory. Do we need
to keep all the files or is there a limit that , how many days worth of
files we need to keep. We do take hot back up of the primary
Hi all -
Are there any open source tools available for migrating from
oracle to postgres. We have 20 tables in oracles that we needed to get to
postgres. Appreciate your help
Regards
...@postnewspapers.com.au* wrote:
From: Craig Ringer cr...@postnewspapers.com.au
Subject: Re: [GENERAL] Oracle to Postgres migration open source tool
To: akp geek akpg...@gmail.com
Cc: pgsql-general pgsql-general@postgresql.org
Date: Thursday, July 7, 2011, 2:02 PM
On 7/07/2011 9:55 PM, akp geek wrote
:51:59 am akp geek wrote:
Thanks all for the responses.
$./configure --prefix=/opt/postgres/9.0.4 --with-readline --with-perl
--with-libxml --with-openssl --with-ossp-uuid
LDFLAGS=-L/opt/postgres/gis/lib
--with-includes=/opt/postgres/software/include/readline/
*I bypassed
/software/include/readline:/opt/postgres/software/flex/bin:/opt/postgres/libxml2/include/libxml2/libxml:/usr/sfw/bin:/usr/local/bin
On Mon, Jun 13, 2011 at 7:32 PM, Craig Ringer
cr...@postnewspapers.com.auwrote:
On 06/14/2011 05:15 AM, akp geek wrote:
Dear all -
While setting up
*
*/platform/SUNW,SPARC-Enterprise/lib/libc_psr.so.1*
Appreciate your help
Regards
On Sat, Jun 11, 2011 at 12:25 PM, Tom Lane t...@sss.pgh.pa.us wrote:
akp geek akpg...@gmail.com writes:
After making the required changes to the Primary and slave , I
have
restarted the slave
Dear all -
While setting up streaming I ran into issue with libpq. To
resolve it I need to recompile the source. I am issuing the following
command . I tried this before with 9.0.2 it worked. Now when issued the same
command I was getting the errors.
./configure
Sorry all -
I am doing the work on Solaris.
Regards
On Mon, Jun 13, 2011 at 5:38 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Mon, Jun 13, 2011 at 3:15 PM, akp geek akpg...@gmail.com wrote:
Dear all -
While setting up streaming I ran into issue
Hi all -
After making the required changes to the Primary and slave , I have
restarted the slave and I keep seeing the following in the logs.
Operating system is solaris.
on the primary . postgresql.conf has the following changes
listen_addresses = '*'
Both the servers are having 9.0.2
Thanks
On Fri, Jun 10, 2011 at 4:09 PM, Guillaume Lelarge
guilla...@lelarge.infowrote:
On Fri, 2011-06-10 at 15:46 -0400, akp geek wrote:
Hi all -
After making the required changes to the Primary and slave ,
I have restarted the slave and I
were mentioning. I
would love to use that to make the data transfer faster
Regards
On Thu, Jun 2, 2011 at 9:32 AM, Thomas Harold thomas-li...@nybeta.comwrote:
On 5/25/2011 3:42 PM, akp geek wrote:
Dear all -
I would like to know if any one has migrated database from
MS access
, akp geek akpg...@gmail.com wrote:
Thanks so much . I was using bullzip What I felt with Bullzip was it is
good
for less amount of data. I have 2 tables each of which has 2.5 million
records. For me it is taking for ever, The job that I set up has been
running since 12 hours.
Export
Dear all -
I would like to know if any one has migrated database from MS
access to Postgres . We use postgres 9.0.2 on solaris . Are there any open
source tools that you have used to do this task. Can you please share your
experiences ?
Regards
It's 10 tables. that's all. No reports. I will follow your suggestion.
Thanks for the help
On Wed, May 25, 2011 at 4:25 PM, John R Pierce pie...@hogranch.com wrote:
On 05/25/11 12:42 PM, akp geek wrote:
Dear all -
I would like to know if any one has migrated database from MS
Hi all -
Is it possible to to split the data of a column into
multiple lines. We are have a column which is text. when the query is
excecuted, I wanted to display the text of the column in separate lines. Is
it possible ?
thanks for the help
Thanks a lot , will try this one
Regards
On Tue, Apr 12, 2011 at 1:59 PM, Andreas Kretschmer
akretsch...@spamfence.net wrote:
akp geek akpg...@gmail.com wrote:
Hi all -
Is it possible to to split the data of a column into
multiple
lines. We are have a column which
hi all -
I am trying to install the pgagent on solaris. when I do the
ccmake /opt/postgres/apps/pgAgent-3.0.1-Source, I am getting the following
error.
CMake Error at cmake/FindWX.cmake:271 (MESSAGE):
The selected wxWidgets configuration (version: 2.6, debug: no, static:
thank you for the clues. I am downloading the package and will install and
update you
Regards
On Fri, Mar 18, 2011 at 4:45 PM, Adrian Klaver adrian.kla...@gmail.comwrote:
On Friday, March 18, 2011 12:36:07 pm akp geek wrote:
hi all -
I am trying to install the pgagent on solaris
Hi All -
I am getting the following error message when I was doing the vacuum
ERROR: Failed with error 22007-invalid value for mm
I am not able to interpret the error. Can you please help?
Thank you
I am getting the following error when I try to restore it from a dump. Any
suggestions?
Regards
Hi all -
I have 2 tables A,B . Can I write a select statement as follows. My query
is running slow ( 7000 ms). I have created gin index on text_col and also
transactionid is PK on both tables. thanks for your help
B has a transactionid and tsvector columns
A has trasactionid and other
Hi all -
wanted to check, if it is possible to recover the database,
if it is deleted using the pgAdmin. I know it is not possible. Just
wondering . We don't have back either :(
Regards
Hi all -
I have recently upgraded from 8.3 to 9.0.2.
when I run the following sql in 9.0.2 select to_timestamp('02/26/2011
14:50', 'MM/DD/ HH24MI') I am getting the following error and
the sql runs fine in older version
Is it my installation issue or library missing?
ERROR:
Unfortunately the our database is still 8.3. that's a limitation for using
array_length
Regards
On Thu, Feb 24, 2011 at 4:08 PM, Dmitriy Igrishin dmit...@gmail.com wrote:
Hey,
2011/2/24 akp geek akpg...@gmail.com
Hi all -
I am trying to find the number of elements
Thank you all for the suggestion and it's very clear to me now
Regards
On Fri, Feb 25, 2011 at 10:02 AM, Bruce Momjian br...@momjian.us wrote:
Adrian Klaver wrote:
test=# select to_timestamp('02/26/2011 14:50', 'MM/DD/ HH24MI');
to_timestamp
Hi all -
I am trying to find the number of elements in the array. Right
now I am using array_upper and array_lower. Is there any other way of
getting the number of elements?
thanks for the help
Regards
Hi all -
I am trying to write a query to find all the column names in
database that has a underscore in it (_) example souce_id. I know like will
not work , if where column_name like '%_%' Can you please help?
Regards
thanks . It worked
Regards
On Thu, Feb 17, 2011 at 2:05 PM, Radosław Smogura
rsmog...@softperience.euwrote:
akp geek akpg...@gmail.com Thursday 17 February 2011 19:55:46
Hi all -
I am trying to write a query to find all the column names in
database that has a underscore
that's right. Thanks again all for the help
On Thu, Feb 17, 2011 at 2:09 PM, David Kerr d...@mr-paradox.net wrote:
On Thu, Feb 17, 2011 at 01:55:46PM -0500, akp geek wrote:
- Hi all -
-
- I am trying to write a query to find all the column names in
- database that has a underscore
Hi All -
I am trying to install postgis 1.5.2 on solaris10. When I run
the configure I get the following.
*configure: WARNING: could not locate CUnit required for
liblwgeom unit tests*
is there some setting I need to do to make it work?
$./configure
installation was successful. But it did not install the liblwgeom.so
Regards
On Mon, Feb 7, 2011 at 12:29 PM, Paul Ramsey pram...@cleverelephant.cawrote:
It's just a warning, continue happily onwards. Just means a few unit tests
won't be run.
P.
On 2011-02-07, at 9:27 AM, akp geek wrote
for upgrading
Regards
On Mon, Feb 7, 2011 at 12:39 PM, Paul Ramsey pram...@cleverelephant.cawrote:
It's not a dynlib, it's statically linked at build time, so have no fear.
Stop thinking so much :)
P
On 2011-02-07, at 9:38 AM, akp geek wrote:
installation was successful. But it did not install
Hi all -
I ran query this morning, I got a wrong results. I have run the same
query in an other environment with same data and I got the result set I was
expecting.
After that I did a re index and on the table I was getting incorrect
results, the data then came out fine,
thanks.. the index I was having is gist on a to_tsvector column . version we
have is 8.3
On Mon, Feb 7, 2011 at 7:23 PM, Alex Hunsaker bada...@gmail.com wrote:
On Mon, Feb 7, 2011 at 17:12, akp geek akpg...@gmail.com wrote:
Hi all -
I ran query this morning, I got a wrong results. I
Hi all -
I have added a column to a table is which of datatype text. I am
trying to create an index
CREATE OR REPLACE FUNCTION reverse(varchar) RETURNS varchar AS $$
$reversed = reverse $_[0];
return $reversed;
$$ LANGUAGE plperlu IMMUTABLE;
CREATE INDEX rev_email ON users(
Hi All -
I created a schema , I used pg_restore with postgres as user
and restored every thing to the new schema I created. Now I want to change
the owner ship of the schema and all its objects to a different user other
than postgres. Is it possible to do that with one command?
Thanks for the help. it worked
On Wed, Dec 1, 2010 at 11:10 AM, Gary Chambers gwch...@gmail.com wrote:
akp geek,
I created a schema , I used pg_restore with postgres as user and restored
every thing to the new schema I
created. Now I want to change the owner ship of the schema and all
Hi All -
Did any one of you build Postgres 9 and postgis package on
solaris 10? I am planning to do one. Any suggestions?
Regards
Thanks for sharing the info. I will post my experiences
Regards
On Wed, Nov 24, 2010 at 10:59 AM, Sebastian Jaenicke
sjaen...@cebitec.uni-bielefeld.de wrote:
On Wed, Nov 24, 2010 at 10:47:18AM -0500, akp geek wrote:
[..]
Did any one of you build Postgres 9 and postgis
One more question. What version of perl do you have? and do we have to
install perl at all or we can use the one that comes with OS?
Regards
On Wed, Nov 24, 2010 at 11:14 AM, akp geek akpg...@gmail.com wrote:
Thanks for sharing the info. I will post my experiences
Regards
On Wed, Nov 24
Dear all -
I am having trouble with replace function inside a function.
If I do the same replace function outside it works fine, Following example
clearly explains my problem. Can you please help?
create table str_table
( mystr varchar(1000));
insert into str_table values (
'plpgsql' VOLATILE
COST 100;
ALTER FUNCTION test_repl(character varying) OWNER TO postgres;
On Tue, Nov 23, 2010 at 3:07 PM, Pavel Stehule pavel.steh...@gmail.comwrote:
Hello
please, can you send a source code of your function?
Regards
Pavel Stehule
2010/11/23 akp geek akpg...@gmail.com
Hi -
This is related to my earlier post. For the function I am passing
a string. But the string some time has a single quote inside the string like
IT's a String Test , How can I handle that, can you please help?
CREATE OR REPLACE FUNCTION test_repl(x character varying)
RETURNS
ret_var;
you can ensure using just buildin replace function - use
ret_var := pg_catalog.replace(...)
Regards
Pavel Stehule
maybe it can help to identify a problem
2010/11/23 akp geek akpg...@gmail.com:
Dear all -
I am having trouble with replace function inside
Thanks for all your valuable thoughts . It took me a while to read all your
suggestions , still trying to understand it fully.
What we do with the text that I have mentioned is, we have
search functionality on the text. The user enters some keywords and then the
application should be able to
Hi all -
I am trying to create an index on character varying field. The
column is just character varying with no limit. I am getting the following
error index row requires 10040 bytes, maximum size is 8191
What can I do the postgres.conf to handle this error? Appreciate your help
Hi All -
Can you please share your thoughts and help me ?
1. I have 4 ( T1, T2 , T3, T4 ) tables where I have the data from
a transactional system
2. I have created one more table D1 to denormalize the data from
the 4 tables ( T1, T2 , T3, T4 )
3. I
:49PM -0500, akp geek wrote:
Hi All -
Can you please share your thoughts and help me ?
1. I have 4 ( T1, T2 , T3, T4 ) tables where I have the data
from
a transactional system
2. I have created one more table D1 to denormalize the data
from
the 4
Hi All -
I need to update one table with the data from multiple
tables.
1. I have created a trigger on a table table
2. Create a view with all the logic
3. created a trigger funtion.
with in the function, I have tried to populate the
Hi all -
I would like to know if there is any other way of moving
objects from one schema to other schema? right now the way I am doing it is
, take the backup and importing whatever the database objects I wanted to
move, I am doing that using pg_restore. But I am finding it
Thanks a lot.
Regards
On Thu, Oct 28, 2010 at 12:23 PM, Pavel Stehule pavel.steh...@gmail.comwrote:
2010/10/28 akp geek akpg...@gmail.com:
Hi all -
I would like to know if there is any other way of moving
objects from one schema to other schema? right now the way I am doing
Hi all -
I am seeing lot of these records in the log file. Not able to
find why I get this in log file. Is there a way to find out info about this
? Thanks for your help
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: unexpected EOF on
Hi all -
Is there a way I can tell table - sequence dependent information.
which sequences are being used by which table?
thanks for the help
Hi all -
Is there a way I can tell table - sequence dependent information.
which sequences are being used by which table?
thanks for the help
Hi all -
Is there any open source tool available for postgres to compare
data between 2 tables. Appreciate your help
Regards
Dear all -
In the postgres db we have, I see there are many pg_toast_temp and
pg_temp schemas are getting created. Is it ok to drop those schemas ? Is
there a way to prevent them being created? Can you please share you
thoughts?
Regards
Thank you all for the responses. I got a requirement from my boss that I
need to give read only access to only tables , so that users can write some
queries. At that time, he also mentioned that the users should not see the
code. I read the document , but not able to figure out how to do that and
Hi all -
Is there way in postgres to set the user privileges so that when
they login , the user can not see functions and views?
Regards
It's not for the user postgres.. If I have created a testuser, can I hide
the code for that testuser?
Regards
On Thu, Jun 24, 2010 at 3:42 PM, Pavel Stehule pavel.steh...@gmail.comwrote:
Hello
2010/6/24 akp geek akpg...@gmail.com:
Hi all -
Is there way in postgres to set
1 - 100 of 174 matches
Mail list logo