uot; utility.
If you are not receiving any kind of error message,try to take a database
dump and restore database dump file in another database server and perform
all sanity checks. If all sanity checks are working fine,you can create a
new cluster and restore all database dump's.
Thanks & Regards
Raghu Ram
PostgreSQL
## su as user "postgres" and run server [sudo su - postgres]:
cd /Library/PostgreSQL/9.1/bin/
./pg_ctl -D /Library/PostgreSQL/9.1/data/ start
## Manually Stop PostgreSQL
./pg_ctl -D /Library/PostgreSQL/9.1/data/ stop
Thanks & Regards
Raghu Ram
On Tue, Aug 26, 2014 at 3:11 PM, Ramesh T
wrote:
> i downloaded But where i need to unzip powa-REL_1_1.zip i'm using putty
> tool remote server..
>
>
> -bash-4.1$ unzip powa-REL_1_1.zip
> -bash: unzip: command not found
>
>
You need to Install "unzip" utility. Once you installed "unzip" utility,y
0 0:00:03 0:00:03 --:--:--
> 120k
> --> Working on Mojolicious
> Fetching http://www.cpan.org/authors/id/S/SR/SRI/Mojolicious-5.33.tar.gz
> ... OK
> Configuring Mojolicious-5.33 ... OK
> Building Mojolicious-5.33 ... OK
> Successfully installed Mojolicious-5.33
> 1 distribution installed
[root@localhost ui]# morbo script/powa
> [Tue Aug 26 00:46:29 2014] [debug] Reading configuration file
> "/tmp/powa-REL_1_1/ui/powa.conf".
> [Tue Aug 26 00:46:29 2014] [info] Listening at "http://*:3000";.
> Server available at http://127.0.0.1:3000.
*Step 7: *Run http://127.0.0.1:3000 in web browser.
Thanks & Regards
Raghu Ram
>
are you referring below Tool ?
PoWA is PostgreSQL Workload Analyzer that gathers performance stats and
provides real-time charts and graph to help monitor and tune your
PostgreSQL servers. It is similar to Oracle AWR or SQL Server MDW.
http://www.postgresql.org/about/news/1537/
Thanks & Regards
Raghu Ram
ncurrency.pdf>
(From
OSCON 2002)
- Recent PostgreSQL Optimizer Improvements (in
7.4)<http://www.postgresql.org/files/developer/optimizer.pdf> (From
OSCON 2003)
Thanks & Regards
Raghu Ram
CTION dump_db(text, text) RETURNS text AS '
#!/bin/sh
pg_dump $1 > $2
' LANGUAGE plsh;
Note that you must CREATE LANGUAGE first, $1 is db_name, $2 is file name
and check for write permissions of $2.
Thanks & Regards
Raghu Ram
to use a variable to set the name.
>
> \set myfile 'filename'
> \! pg_dumpall > /mydir/:myfile
>
> Doesn't seem to work.
>
> Any ideas?
>
Below URL provides more information of Automated database Backup's on Linux:
http://wiki.postgresql.org/wiki/Automated_Backup_on_Linux
Thanks & Regards
Raghu Ram
,,8855,,523c23ea.2297,22,,2013-09-20 16:01:06
> IST,,0,LOG,F,"configuration file
> ""/pgdata/prod/data_93/postgresql.conf"" contains errors; unaffected
> changes were applied",""
>
To effect new changes related to "superuser_reserved_connections"
parameters in Postgresql.conf file requires RESTART of the PostgreSQL
Service.
Thanks & Regards
Raghu Ram
r and seems to have a larger
community however)
- Free and open source
- They are complex enough to handle a lot of tasks, but not so much as
to kill you
- There are versions of both (GeoKettle and Spatial Data Integrator)
that are tailored for GIS
Thanks & Regards
Raghu Ram
may hamper us?
>
>
You can get more information with below Link:
http://zetcode.com/db/postgresqljavatutorial/
Thanks & Regards
Raghu Ram
new record must be created if the item_master is not
> present in postablestatus
>
>
> You will get more information from below link for creation of audit
trigger:
http://wiki.postgresql.org/wiki/Audit_trigger
Thanks & Regards
Raghu Ram
> how to see list of system tables, functions, view and user defined tables,
> functions, views.
>
>
You can get more details from below URL:
Extracting META information from PostgreSQL
(INFORMATION_SCHEMA)<http://www.alberton.info/postgresql_meta_info.html>
Thanks & Regards
Raghu Ram
a missed "pg_clog" file with below command:
dd if=/dev/zero of=~/9.1/main/pg_clog/0008 bs=256k count=1 (To make the
uncommitted record as they haven't been committed.)
and then try to start the cluster.
Thanks & Regards
Raghu Ram
OR You can delete the user and then have the installer recreate the user.
You will need to be logged into the computer as an administrative user to
do the above.
Thanks & Regards
Raghu Ram
-C src/include install
> gmake -C src/interfaces install
> gmake -C doc install
>
>
>
> Any information is appreciated.
>
You can download PostgreSQL binaries for windows operating system from
below link:
http://www.enterprisedb.com/products-services-training/pgbindownload
Thanks & Regards,
Raghu Ram
SkypeID: raghu.ramedb
gt; look to good.
>
Below URL provides more information on this topic:
http://serverfault.com/questions/222430/is-postgresql-suited-to-one-os-is-it-better-on-linux-than-windows
--
Thanks & Regards,
Raghu Ram
EnterpriseDB Corporation
Blog:http://raghurc.blogspot.in/
as the database engine needs more working
space for other requests.
A permanent table persist after terminating PostgreSQL session, whereas
temporary table is automatically destroyed when PostgreSQL session ends.
The memory is controlled by temp_buffers parameter (postgresql.conf)
--
Thanks
rom archive
> [2012-11-22 18:50:54.459 CST 25744 50ae0334.6490 16 0]LOG: restored
> log file "00010028002E" from archive
> [2012-11-22 18:50:54.920 CST 25744 50ae0334.6490 17 0]LOG: restored
> log file "000000010028002F" from archive
> cp: cannot stat `/export/t/xlog/000100280030': No such file or
> directory
> cp: cannot stat `/export/t/xlog/000100280030': No such file or
> directory
>
>
>
> As per logs,it is working as a host-standby. For doing the point in time
recovery,recovery.conf file requires only two settings:
restore_command='cp /t/xlog/%f %p'
recovery_target_time='2012-11-22 5:01:09 CST'
--Raghu Ram
Operating System:
http://www.mokisystems.com/blog/setting-up-slony-on-windows/
Thanks & Regards,
Raghu Ram
EnterpriseDB Corporation
Blog:http://raghurc.blogspot.in/
= 5
> wal_sender_delay = 200ms
> wal_keep_segments = 128
> vacuum_defer_cleanup_age = 0
> hot_standby = on
> max_standby_archive_delay = -1
> max_standby_streaming_delay = -1
PostgreSQL version: 9.0.4
OS: Solaris 64bit
Could you please share your inputs,to fix this issue.
Thanks & Regards,
Raghu Ram
Thanks.
>
>
Could you please check permission of /var/run/pgbouncer/ directory. If
pgbouncer directory does not have "postgres" user permissions,please assign
it and then start the pgbouncer.
Looking to the error thrown by pgbouncer the port shown up as 6789, but
whereas the l
AND d2.deptype='i')
JOIN pg_attribute a ON (d1.refobjid = a.attrelid
AND d1.refobjsubid = a.attnum)
WHERE d1.refobjid=*'base_table'*::regclass
ORDER BY 1, 2, 3;
--
Thanks & Regards,
Raghu Ram
EnterpriseDB Corporation
Blog:http://raghurc.blogspot.in/
tm
ON (
other_stm.procpid = other.pid
)
WHERE
NOT waiting.granted
AND
waiting.pid <> other.pid;
--
Thanks & Regards,
Raghu Ram
EnterpriseDB Corporation
Blog:http://raghurc.blogspot.in/
itted. command as follows:
*dd if=/dev/zero of=/pg_clog/0003 bs=256K count=1
*
3. Start the Cluster
--
Thanks & Regards,
Raghu Ram
EnterpriseDB Corporation
Blog:http://raghurc.blogspot.in/
eeds,you will get this error
message. For fixing this issue,please set max_locks_per_transaction
to (tables in database)/max_connections.
Thanks & Regards,
Raghu Ram
EnterpriseDB Corporation
Blog:http://raghurc.blogspot.in/
link gives more information of
reseting password in windows7
http://pcsupport.about.com/od/windows7/ht/change-password-windows-7.htm
Thanks & Regards,
Raghu Ram
EnterpriseDB Corporation
Blog:http://raghurc.blogspot.in/
abase/postgresql-point-in-time-recovery-incremental-backup/
Thanks & Regards,
Raghu Ram
//raghavt.blogspot.in/2012/07/simple-slony-i-replication-setup.html
Thanks & Regards,
Raghu Ram
>
> Thanks Raghu.
>
> BTW,could you solve my other(makefile) issue please?
>
> Atri
>
>
> Sorry about Makefile issue, someone would have better solution on it..
-Raghu Ram
>
>
> Hi John,
>
> What values should I be setting in PGDATA and PGPORT?
>
>
Below URL provides more information on this:
http://www.postgresql.org/docs/9.1/static/libpq-envars.html
--
Thanks & Regards,
Raghu Ram
both from scratch and install them independently
> this time?
>
cd
./configure
make distclean
Remove "pgsql" directory from /usr/local
and then you can build both from scratch and install them independently
--
Thanks & Regards,
Raghu Ram
help me.What should I be doing to recover from this error and
> get back to 9.1?
>
>
Suspecting for this error message is, binaries upgraded upto 9.2beta2 &
PostgreSQL instance running with PostgreSQL 9.1 binaries and again you are
trying to start instance with pg_ctl of 9.2beta2 binary.
--
Thanks & Regards,
Raghu Ram
ow)
postgres=# select 24612::regprocedure;
regprocedure
-
myfunc(integer)
--
Thanks & Regards,
Raghu Ram
y:
Syntax: /bin/pg_ctl -D start
Ex:- /opt/PostgreSQL/8.4/bin/pg_ctl -D /opt/PostgreSQL/8.4/data start
and then share the log file information
--
Thanks & Regards,
Raghu Ram
Skypeid: raghu.ramedb
EnterpriseDB: http://www.enterprisedb.com
2/pg9.1/archivelog %r'
[to]
archive_cleanup_command = '/opt/PostgreSQL/9.1/bin/pg_archivecleanup
-d /attend_pg_backup/u02/pg9.1/archivelog %r 2>>/tmp/cleanup.log'
and then restart the Standby PostgreSQL cluster.
--
Thanks & Regards,
Raghu Ram
EnterpriseDB: http://www.enterprisedb.com
On Sat, Apr 14, 2012 at 6:35 PM, Clodoaldo Neto <
clodoaldo.pinto.n...@gmail.com> wrote:
> Em 14 de abril de 2012 09:39, raghu ram escreveu:
>
>>
>>
>> On Sat, Apr 14, 2012 at 4:31 PM, Clodoaldo Neto <
>> clodoaldo.pinto.n...@gmail.com> wrote:
>>
in the pgbouncer log file after updating to the last
> version, 1.5, in Centos 6. For me the fix was to set the ownership of the
> auth_file to pgbouncer. In the previous version, 1.4, it was working with
> postgres as the owner of that file.
>
> Regards, Clodoaldo
>
Could you please share stats_users information in pgbouncer.ini file ?
--
Thanks & Regards,
Raghu Ram
EnterpriseDB: http://www.enterprisedb.com
|
public | postgres | {postgres=UC/postgres,=UC/postgres} |
standard public schema
(5 rows)
--
Thanks & Regards,
Raghu Ram
EnterpriseDB: http://www.enterprisedb.com
//www.kde.org/applications/development/kompare/]* to get a diffbetween two
schema files and see where there is a change in the schema.
--
Thanks & Regards,
Raghu Ram
EnterpriseDB: http://www.enterprisedb.com
n RELOAD the PostgreSQL cluster.
--
Thanks & Regards,
Raghu Ram
EnterpriseDB: http://www.enterprisedb.com
On Tue, Apr 10, 2012 at 12:39 PM, tuanhoanganh wrote:
> I am running windows 2003 R2 (64 bit) - PostgreSQL 9.0.6 - 64bit.
> Today PostgreSQL has alot pgstat wait timeout in log.
> How to fix the PostgreSQL WARNING??
>
> Tuan Hoang ANh
>
>
This warning message shows in database server log file, if
on.
Ex: ./configure --prefix=/usr/local/pgsql83
./configure --prefix=/usr/local/pgsql84
Once completion of PostgreSQL installation,you will see
"bin,include,lib,share" directories are created under the
/usr/local/pgsql83 location.
--Raghu Ram
2011/10/20 Birta Levente
> Hi
>
> I use postgrsql 9.1.1 and I want to change archive_timeout on a running
> server. My default archive_timeout is 1800s, and nightly I want to change to
> 3600s or more, but I get the following error message:
>
> set archive_timeout='3600';
> ERROR: parameter "arc
trigger all;
You can use this command inside your transaction too, but don't forget to
reactivate the triggers because this change will become global after
the transaction ends!
--Raghu
> On 10/21/2011 11:12 AM, raghu ram wrote:
>
>>
>>
>> On Fri, Oct 21, 2011 at 8:33
On Fri, Oct 21, 2011 at 8:33 PM, Emi Lu wrote:
> Good morning,
>
>
> Is there a way to temporally disabled foreign key constraints something
> like:
>
> SET FOREIGN_KEY_CHECKS=0
>
> When population is done, will set FOREIGN_KEY_CHECKS=1
>
>
You can disable *triggers* on a table (which will disabl
atgreSQL 8.4.1 :
*
*
*ftp://ftp-archives.postgresql.org/pub/source/v8.3.8/postgresql-8.3.8.tar.gz
*
*ftp://ftp-archives.postgresql.org/pub/source/v8.4.1/postgresql-8.4.1.tar.gz
*
*--Raghu Ram*
t;.
[pgsql@test~]$ pg_controldata /usr/local/pgsql/data84/
Database cluster state: in archive recovery --> This is
Standby Database
Database cluster state: in production --> This is Production
Database [Master]
--Raghu Ram
resdac/help/TPSQLDump/Methods/DumpToFile.htm
--Raghu Ram
On Tue, May 3, 2011 at 6:01 PM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
>
> On Tue, May 3, 2011 at 5:37 PM, Simon Riggs wrote:
>
>> On Tue, May 3, 2011 at 11:54 AM, raghu ram
>> wrote:
>>
>> > It may be a silly question, still out of curi
Respected Committers,
It may be a silly question, still out of curiosity I want to know, is there
any possible way to flush the Postgres Shared Memory without restarting the
cluster.
In Oracle, we can flush the SGA, can we get the same feature here..
Thanks in Advance.
Regards
Raghu Ram
#x27;);
psql=# insert into rownumtest(val1,val2) values('ghi', '3');
psql=# insert into rownumtest(val1,val2) values('jkl', '4');
psql=# select * from rownumtest;
rownum | val1 | val2
+--+--
1 | abc | 1
2 | def | 2
3 | ghi | 3
4 | jkl | 4
Hope this helps
--Raghu Ram
PGsnap module will describes tables,Indexes,Sequences I/O statistics and
URL as follows
http://pgsnap.projects.postgresql.org/fluxbb_snap_20100513/bgwriter.html
pg_buffercache module will shows memory usage on particular tables.
--Raghu Ram
> And also the timing result that gets displayed, i
pre Postgresql-8.4::
http://www.postgresonline.com/journal/archives/79-Simulating-Row-Number-in-PostgreSQL-Pre-8.4.html
--Raghu Ram
> Thanks a lot!
> 丁叶
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
k.sql
2)Insert into the database
user> psql -U test -d DatabaseName -f mp_census_block.sql
--Raghu Ram
>
> On Wed, Apr 20, 2011 at 4:31 PM, raghu ram wrote:
>
>>
>>
>> On Wed, Apr 20, 2011 at 12:32 PM, Mlondolozi Ncapayi > > wrote:
>>
>>> Hi
r PostgreSQL 8.4 installation including user
and installation directories.
--Raghu Ram
>
> Mlo
>
>
>
Hi,
Is there any limitations to configure streaming replication between
different operating systems i.e solaris 64 bit to RHEL 64 bit.
--Raghu Ram
*--configure*
Print the options that were given to the *configure* script when PostgreSQL
was configured for building. This can be used to reproduce the identical
configuration, or to find out with what options a binary package was built.
--Raghu Ram
> WBL
>
>
> On Thu, Mar 24, 20
Hi,
I was installed the Postgresql 8.3 and trying the use the
"pg_lesslog_1.4.1_pg83" to reduce the size of WAL file when the WAL file is
archived.
1. Download the "pg_lesslog_1.4.1_pg83.tar.gz" file from pgfoundry.
2. unpacked the pglesslog source.
3. trying to run the "make"...facing below is
On Tue, Jun 29, 2010 at 3:23 PM, Vibhor Kumar wrote:
> On 28/06/10 11:14 PM, raghu ram wrote:
>
>>
>> Hi,
>>
>>
>>
>> We are using pgool-II version 2.3.2.2 (tomiteboshi)and postgres 8.3.9 and
>> facing the below error while running the select quer
Hi,
We are using pgool-II version 2.3.2.2 (tomiteboshi)and postgres 8.3.9 and
facing the below error while running the select queries in the application
side::
ERROR: prepared statement
"mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e" does not exist
STATEMENT: DEALLOCATE PREPARE
md
LinkedIn
I'd like to add you to my professional network on LinkedIn.
- raghu
Accept raghu ram's invite:
https://www.linkedin.com/e/isd/734105299/D0TiGEdR/
--
(c) 2009, LinkedIn Corporation
Environment Variable -> set the path.
>
>
> Thanks & Regards,
> Vibhor Kumar
> www.enterprisedb.com
>
>
> raghu ram wrote:
>
>> Hi All,
>>
>> Can anyone tel me what does this error mean. “ 'more' is not recognized as
>> an internal or
Hi All,
Can anyone tel me what does this error mean. “ 'more' is not recognized as
an internal or external command, operable program or batch file. “
C:\Program Files\PostgresPlus\8.4\bin>psql -d postgres -p 5456 -U postgres
psql (8.4rc1)
WARNING: Console code page (437) differs from Windows cod
64 matches
Mail list logo
