Probably what you need is to have a different schemes instead
From: manasi.s...@artificialmachines.com
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Creating multiple database at runtime in postgresql
Date: Thu, 2 Dec 2010 04:35:25 -0500
Dear All,
I am new to postgresql database. I want
I think you can do something like that as a postgresql user
su - postgres
psql -c "\! uname -n"
or actually you can do that inside of any sql statement
psql
\!uname -n
> Date: Fri, 30 Apr 2010 09:14:04 -0500
> From: reeds...@rice.edu
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN
su - postgres
psql dbname -c "show all"
> Date: Tue, 13 Apr 2010 13:13:58 -0400
> From: g...@2ndquadrant.com
> To: sburn...@cisco.com
> CC: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Getting the initdb parameter values
>
> Satish Burnwal (sburnwal) wrote:
> >
> > I have an existing postg
check this
http://symmetricds.codehaus.org/
I just began playing with that one
> Date: Thu, 19 Nov 2009 12:39:04 -0600
> From: kevin.gritt...@wicourts.gov
> To: pthiyagara...@cashedge.com; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Replication solution
>
> Palaniappan Thiyagarajan wro
as postgres user
psql -c "select version()";
From: louis@guardium.com
Date: Thu, 8 Oct 2009 16:58:33 -0400
Subject: [ADMIN] How to tell what OS PostgreSQL is installed on.
To: pgsql-admin@postgresql.org
Hi,
I have a need to find out what OS PostgreSQL is running
under.
Use pgadmin
Date: Fri, 2 Oct 2009 13:35:51 -0300
Subject: Re: [ADMIN] where the stored function meta data can be found?
From: rafael.domici...@gmail.com
To: jul...@nsoft.lt
CC: pgsql-admin@postgresql.org
Hello,
I Think you can this kind of information at pg_proc.prosrc
Best Regardas,
Rafael D
> Subject: Re: [ADMIN] Help With Database Backup
> From: andy-li...@networkmail.eu
> Date: Wed, 30 Sep 2009 22:24:27 +0100
> CC: pgsql-admin@postgresql.org
> To: chal...@yahoo.com
>
> Hi,
>
> >
> > Hello there, I am new to PostgreSQL, succeded in running a little
> > database on
> > my dev.
ps -ef | grep postgres
> Date: Mon, 2 Mar 2009 22:35:23 +0200
> Subject: Re: [ADMIN] Database in use?
> From: lu...@fmf.vtu.lt
> To: pgsql-admin@postgresql.org
>
> Hi,
>
> try this:
> SELECT * FROM pg_stat_activity;
>
> Maybe it will show you who is using it..
>
>
> --
> Lukas
> UAB nSoft
We have a transactional D.B writing directly to postgres (8.3) and these
parameters have worked ok for us
checkpoint_timeout = 5min
checkpoint_segments = 10
wal_buffers = 1024kB
Date: Wed, 8 Oct 2008 12:34:00 -0200
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: [ADMIN] checkpoint
> Date: Wed, 27 Aug 2008 06:58:33 -0700
> From: [EMAIL PROTECTED]
> Subject: Re: [ADMIN] [GENERAL] PITR - base backup question
> To: [EMAIL PROTECTED]; pgsql-admin@postgresql.org; [EMAIL PROTECTED]
>
>
>
>
> --- On Tue, 8/26/08, Richard Broersma wrote
I have setup this feature using postgresql 8.3.1 on a suse linux version
and pg_standby as a recovery script, works very good and I use rsync as a
script to ship logs
This is my configuration in the primary D.B
archive_mode = on
archive_command = 'rsync -atz %p backup:/data01/wal_files/%f
double check pg_hba.conf
> From: [EMAIL PROTECTED]
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] LAN connection to server only after restart server
> Date: Thu, 13 Mar 2008 10:20:07 +0100
>
> Hi,
>
> I have strange behaviour on my LAN.
>
> Postgresql server is up and running, accepti
$dbase=pg_connect("host=xx.xx.xx.xx port=5432 dbname=name user=username
password=password" );
From: [EMAIL PROTECTED]
To: pgsql-admin@postgresql.org
Subject: [ADMIN] hel??
Date: Tue, 11 Mar 2008 09:44:36 +0200
I need to connect postgresql 8.2 with php
how I c
Linux is sensitive to uppercase or lowercase
make sure your script has all the tables names as they are shown in postgresql
su - postgres
\d
check all the names
I ran into that problem awhile ago..
Date: Fri, 8 Feb 2008 18:47:02 +0500
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re:
Hi all
We have been 'fighting' with the performance of our app for some days now.We
don't know exactly how wal log files and check points exactly work behind
scenes.
We found that incrementing the checkpoint_segments and increasing the
wal_buffers the performance of our app goes up.
Our app is
Subject: [ADMIN] Need some help in psql ConfigurationDate: Mon, 31 Dec 2007
11:51:38 +0530From: [EMAIL PROTECTED]: [EMAIL PROTECTED];
pgsql-admin@postgresql.org
Hi Team,
I am using Postgresql 7.4 version. We are
willing to update the version to the latest. Can you p
We use Toad Data Modeler
Is not free though
http://www.quest.com/Toad-Data-Modeler/
From: [EMAIL PROTECTED]
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Looking for an E/R tool for Postgres
Date: Mon, 17 Dec 2007 11:58:21 -0500
Does anybody have suggestions as to w
also make sure you started postgesql with -i option, so you can connect from
the lan
Julioc.
> From: [EMAIL PROTECTED]
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] pg_hba.conf is driving me nuts
> Date: Sat, 15 Dec 2007 13:39:44 +0200
>
> Hi..
Hi allI'm trying to get the next value from a sequence using a store procedure
like thiscreate or replace function givemenext() returns integer AS
$$DECLAREnewvalue integer;getseq varchar(256);BEGINreturn EXECUTE 'SELECT
nextval(''test_id_seq'')';END;$$ language plpgsqlSo when I do select * fro
Check your pg_hba.conf file if the method is password, then create a pasword
for postgres userpsql yourdbalter user postgres set password = 'pasword'if you
don't want to do that, change pg_hba.conf file and modify the method to
trustthen /etc/init.t/./postgresql reloadHope this will helpSubject
Hi allI'm trying to create a function that alters a sequenceThis what I'm
doingcreate or replace function updatesafe() returns integer AS
$$DECLAREmaxseq integer;alterseq varchar(256);thumb integer;newvalue
integer;BEGINnewvalue := 10010; maxseq := (select max(safeoperationid) from
safeopenc
21 matches
Mail list logo
