Hello,
Can I use windows default service account LocalSystem for psql service
account when installing.
On Thu, Jun 5, 2014 at 11:01 AM, Kalai R softlinne...@gmail.com wrote:
Thank You for your suggestions.
In silent installation we use the following code in vb.net to install
postgres
Hi everyone, I wonder if you could help me with a procedure that I would
like to perform in postgresql.
I have an insert query like this:
INSERT INTO products (product_id, description, price, qty, ...) values
('01', 'some description', 10.15, 5, ...)
then if there is no problem, perform another
2014-06-05 9:32 GMT-06:00 Carlos Carcamo eazyd...@gmail.com:
Hi everyone, I wonder if you could help me with a procedure that I would
like to perform in postgresql.
I have an insert query like this:
INSERT INTO products (product_id, description, price, qty, ...) values
('01', 'some
Hi Carlos,
Unless I'm missing something here, your queries are probably being called
from a programming language (java/c# etc) and your database access api
should support transactions. If you perform both operations under the same
db transaction and commit your transaction things should be fine.
On Wed, Jun 4, 2014 at 1:50 PM, Keith Fiske ke...@omniti.com wrote:
Not sure if this will work for you, but sharing a similar scenario in case
it may work for you.
An extension I wrote provides similar logical replication as you've
probably seen in other tools.
It did create the data directory as well pg_log directory. I ran the initdb
again with -d option, but it still printed the same line in the startup
log, nothing more.
$SU -l postgres -c $PGENGINE/initdb --pgdata='$PGDATA' --auth='ident'
$LOCALESTRING -d $PGLOG 21 /dev/null
I then ran the pg_ctl
Hi Carlos,
When you say procedures, do you mean calling a stored procedure you'll
write from php? Or executing the individual INSERT from php sequentially?
For the first scenario, you'd need to write a postgresql stored procedure
(I suggest you google: PL/pgSQL tutorial) and call the from php. For
Sorry, I meant: calling a stored procedure you'll write in postgres from
php
On Thu, Jun 5, 2014 at 5:13 PM, Seref Arikan serefari...@gmail.com wrote:
Hi Carlos,
When you say procedures, do you mean calling a stored procedure you'll
write from php? Or executing the individual INSERT from php
What I need is some help with the procedure in postgres, I have searched in
google, but I dont know how to do it, the goal is perform the first insert
and then the second insert if the first one succeed in one procedure
instead of using two separate inserts.
Do you have some code like that?
Have you read this chapter of the documentation?
http://www.postgresql.org/docs/9.3/interactive/plpgsql.html
Carlos Carcamo wrote
What I need is some help with the procedure in postgres, I have searched
in
google, but I dont know how to do it, the goal is perform the first insert
and then
Just a little, I will read it again, thanks for your help.
2014-06-05 10:39 GMT-06:00 David G Johnston david.g.johns...@gmail.com:
Have you read this chapter of the documentation?
http://www.postgresql.org/docs/9.3/interactive/plpgsql.html
Carlos Carcamo wrote
What I need is some help
Hi Sébastien:
On Thu, Jun 5, 2014 at 5:41 PM, Sébastien Lorion
s...@thestrangefactory.com wrote:
Correct me if I am wrong, but will it not also suffer the same
limitation as any statement based replication, namely that the merged
slave will have to sustain the same write load as all
On Wed, Apr 16, 2014 at 9:08 PM, Dev Kumkar devdas.kum...@gmail.com wrote:
On Wed, Apr 16, 2014 at 7:50 PM, Stephen Frost sfr...@snowman.net wrote:
* Dev Kumkar (devdas.kum...@gmail.com) wrote:
I just downloaded the latest binaries from EnterpriseDB and when checked
with libssl.so.1.0.0
On Thu, Jun 5, 2014 at 7:30 PM, Dev Kumkar devdas.kum...@gmail.com wrote:
On Wed, Apr 16, 2014 at 9:08 PM, Dev Kumkar devdas.kum...@gmail.com
wrote:
On Wed, Apr 16, 2014 at 7:50 PM, Stephen Frost sfr...@snowman.net
wrote:
* Dev Kumkar (devdas.kum...@gmail.com) wrote:
I just downloaded
On Thu, Jun 5, 2014 at 12:55 PM, Francisco Olarte fola...@peoplecall.com
wrote:
Hi Sébastien:
On Thu, Jun 5, 2014 at 5:41 PM, Sébastien Lorion
s...@thestrangefactory.com wrote:
Correct me if I am wrong, but will it not also suffer the same
limitation as any statement based
Carlos Carcamo wrote
SELECT myProcedure(product_id, p_description, price, qty, store_id,
store_description );
waiting for a response from procedure, maybe true or false.
Note that forcing the procedure to return false instead of simply throwing
an error is going to degrade performance. If
On Thu, Jun 5, 2014 at 11:03 PM, Magnus Hagander mag...@hagander.net
wrote:
Hi!
The guys at EnterpriseDB are busy building new installers as we speak, I
would expect them to be out tomorrow or so.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
debian jessie 9.3 latest upgrade
su - postgres
password: x
== Authentication failure
edited pg_hba.conf == local all all trust
restarted
still failure
sudo -u postgres
pgsql
=== access
okay, figure this is a problem with postgresql user vs linux user - but
how to fix ? is it
On 6/5/2014 12:24 PM, john.tiger wrote:
debian jessie 9.3 latest upgrade
su - postgres
password: x
== Authentication failure
thats the operating system user.to set it, try...
sudo passwd postgres
or, just use sudo as you did later.
edited pg_hba.conf == local all all
On Jun 5, 2014, at 3:24 PM, john.tiger john.tigernas...@gmail.com wrote:
okay, figure this is a problem with postgresql user vs linux user - but how
to fix ?
John,
su and sudo are OS commands and the examples you provide using them demonstrate
attempts to start a shell as the postgres, OS
I have the following query:
SELECT r.reset
FROM tb_reset r
LEFT JOIN tb_project pj ON pj.project = r.project
LEFT JOIN tb_location l ON l.location = r.location
LEFT JOIN tb_program pg ON pg.program = r.program
LEFT JOIN tb_reset_survey rsv ON rsv.reset = r.reset
LEFT JOIN
On 6/5/2014 2:43 PM, Moshe Jacobson wrote:
The EXPLAIN ANALYZE for this query indicates that all of the tables in
the query are being joined despite the fact that they are not needed
at all.
Why is this?
why would you join 28 tables you're not using ??
--
john r pierce
On Thu, Jun 5, 2014 at 6:09 PM, John R Pierce pie...@hogranch.com wrote:
why would you join 28 tables you're not using ??
The query is derived from a view. I want to select only one column from a
view with many columns. I figured the optimizer would be smart enough in
this case not to join all
Moshe Jacobson wrote
I have the following query:
[...]
The EXPLAIN ANALYZE for this query indicates that all of the tables in the
query are being joined despite the fact that they are not needed at all.
Why is this?
Without definitions of all the tables involved, as well as knowing what
On Thu, Jun 5, 2014 at 2:09 PM, Sébastien Lorion s...@thestrangefactory.com
wrote:
On Thu, Jun 5, 2014 at 12:55 PM, Francisco Olarte fola...@peoplecall.com
wrote:
Hi Sébastien:
On Thu, Jun 5, 2014 at 5:41 PM, Sébastien Lorion
s...@thestrangefactory.com wrote:
Correct me if I am
On Thu, Jun 5, 2014 at 6:38 PM, David G Johnston david.g.johns...@gmail.com
wrote:
Without definitions of all the tables involved, as well as knowing what
version you are running this query on, it is impossible to explain why.
I'm running 9.3.4.
Moshe Jacobson mo...@neadwerx.com writes:
On Thu, Jun 5, 2014 at 6:38 PM, David G Johnston david.g.johns...@gmail.com
wrote:
Without definitions of all the tables involved, as well as knowing what
version you are running this query on, it is impossible to explain why.
Right, I'm aware of
On 06/05/2014 09:11 AM, Bhushan Pathak wrote:
It did create the data directory as well pg_log directory. I ran the
initdb again with -d option, but it still printed the same line in the
startup log, nothing more.
$SU -l postgres -c $PGENGINE/initdb --pgdata='$PGDATA' --auth='ident'
$LOCALESTRING
On 06/05/2014 09:45 AM, Carlos Carcamo wrote:
Just a little, I will read it again, thanks for your help.
In particular:
http://www.postgresql.org/docs/9.3/interactive/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via
Hi,
on a server running 8.4 I observe that, since a while, the pg_attribute table
is growing
enormously.
Soon after reloading I have one file
ls -s 1249
1048580 1249
a day later this is
1048580 1249
1048580 1249.1
1048580 1249.10
1048580 1249.11
1048580 1249.12
1048580 1249.13
1048580 1249.14
hamann.w wrote
Hi,
on a server running 8.4 I observe that, since a while, the pg_attribute
table is growing
enormously.
Soon after reloading I have one file
ls -s 1249
1048580 1249
a day later this is
1048580 1249
1048580 1249.1
1048580 1249.10
1048580 1249.11
1048580 1249.12
31 matches
Mail list logo