> Hello,
>
> I found some subjects like mine on many forums, but the given solution
> doesn't work for me.
>
> I'm using PostgreSQL 8.4. I'm working on a C# application.
>
> When connecting to the application, a temporary table myTableTemp is created.
> This table is available for all the appl
Nikhil G. Daddikar, 01.04.2010 08:04:
In about 30 seconds I found the following unanswered threads relating to
installation on Windows Vista. If anybody is interested I can find more.
The problem with this kind of statistics is that you will only find people who complain,
you'll never find pe
Hi,
We have been using a stored procedure which allow users to create table. The
stored procedure creates actual table, logging tables, views, and applies
triggers. I want to prevent table owner from deleting the triggers applied
on table by create table stored procedure. Could anyone please sugge
> Hello,
>
> I found some subjects like mine on many forums, but the given solution
> doesn't work for me.
>
> I'm using PostgreSQL 8.4. I'm working on a C# application.
>
> When connecting to the application, a temporary table myTableTemp is created.
> This table is available for all the appli
I don't think you can do it. You have to parse the string you got from
pg_namespace to get the current user's permissions.
On Thu, Apr 1, 2010 at 11:09 AM, dipti shah wrote:
> Hi,
>
> I ran below command to list out all privileges of objects if "mydb" schema.
> Actually, I want to know what are
On 01-04-2010 12:39, Thomas Kellerer wrote:
Nikhil G. Daddikar, 01.04.2010 08:04:
In about 30 seconds I found the following unanswered threads relating to
installation on Windows Vista. If anybody is interested I can find more.
The problem with this kind of statistics is that you will only
Thomas Kellerer wrote:
> All the posts seem to share the same root cause: the data directory has
> been put into "c:\Program Files" but a regular user does not have write
> permissions on that directory.
Yep. They're also often confused by various steps people have tried
while attempting to get i
Not sure about how de C# driver you use to connect, but if you have
multiple connections, then you have multiple sessions.
2010/4/1 Sylvain Lara :
>> Hello,
>>
>> I found some subjects like mine on many forums, but the given solution
>> doesn't work for me.
>>
>> I'm using PostgreSQL 8.4. I'm work
dipti shah wrote:
Hi,
We have been using a stored procedure which allow users to create
table. The stored procedure creates actual table, logging tables,
views, and applies triggers. I want to prevent table owner from
deleting the triggers applied on table by create table stored
procedure. C
Craig Ringer, 01.04.2010 09:24:
I do not like the installer's suggestion to put the data directory into
c:\Program Files either, I think this should default to %APPDATA%
That seems fairly sensible *IF* it checks very carefully to make sure
the postgresql user does not have a roaming profile, ie
Yah...that's correct but I am wondering if someone out there knows work
around to this.
I could make my table owner to postgres user but then is there any way
original user can drop the table. I want original users should allow to drop
their table.
Thanks,
Dipti
On Thu, Apr 1, 2010 at 12:58 PM,
I too much preferred the older installer to that oneclick thing, and
regret that we the users aren't at least given a choice.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Apr 1, 2010 at 8:57 AM, John R Pierce wrote:
> I too much preferred the older installer to that oneclick thing, and regret
> that we the users aren't at least given a choice.
You're free to maintain the old one if you like. Be warned though - it
had a much higher failure rate than the one
Following a great deal of discussion, I'm pleased to announce that the
PostgreSQL Core team has decided that the major theme for the 9.1
release, due in 2011, will be 'NoSQL'.
There is a growing trend towards NoSQL databases, with major sites
like Twitter and Facebook utilising them extensively. N
On Thu, Apr 1, 2010 at 6:47 AM, Nikhil G. Daddikar wrote:
> Folks,
>
> Here is my original ticket. It has the screen shot as well as the logs.
> Like many other threads on this forum it remains unresolved.
>
> http://forums.enterprisedb.com/posts/list/2235.page
>
> What I would like from EDB is a
On 1 April 2010 09:13, Dave Page wrote:
> Following a great deal of discussion, I'm pleased to announce that the
> PostgreSQL Core team has decided that the major theme for the 9.1
> release, due in 2011, will be 'NoSQL'.
>
> There is a growing trend towards NoSQL databases, with major sites
> li
On Thu, Apr 1, 2010 at 9:30 AM, Thom Brown wrote:
> I prefer to dump all my data in a big text file and grep it for the
> information I need.
There's no need to start showing off and get all technical y'know.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general
Hi Dave,
thanks for this funny post on April, 1st ;-)
It's currently the highlight of my working day here
regards..GERD..
On Thursday 01 April 2010 10:13:16 am Dave Page wrote:
> Following a great deal of discussion, I'm pleased to announce that the
> PostgreSQL Core team has decided that t
Ciao Dave,
> You may also notice that without SQL, the project name is somewhat
> misleading. To address that, the project name will be changed to
> 'PostgreQUEL' with the 9.1 release. We expect this will also put an
> end to the periodic debates on changing the project name.
Ahahahah ... nice fi
2010/4/1 Sylvain Lara :
>> Hello,
>>
>> I found some subjects like mine on many forums, but the given solution
>> doesn't work for me.
>>
>> I'm using PostgreSQL 8.4. I'm working on a C# application.
>>
>> When connecting to the application, a temporary table myTableTemp is
>> created.
>> This tab
Nice to hear and thumbs up! I've just start planning to migrate one of
my telco 3Tb database running blunt oracle to coachDb but now of
course postgres looks better. Hopefully stupid transactions will be
abrogated to
wbr Ilya
On Thu, Apr 1, 2010 at 12:33 PM, Dave Page wrote:
> On Thu, Apr 1, 20
On Thu, Apr 1, 2010 at 8:24 AM, Craig Ringer
wrote:
> Thomas Kellerer wrote:
>
>> All the posts seem to share the same root cause: the data directory has
>> been put into "c:\Program Files" but a regular user does not have write
>> permissions on that directory.
>
> Yep. They're also often confuse
Thanks for answering
Yes, you are right. This is a client-side file. However, our concern is
that we have to consider this practice as a security issue. We'd like to
ban this practice for our product which is, thus, wrapping PostgresQL
engine. Thus my questions
- is there any configuration that c
Le 01/04/2010 11:21, Christophe Dore a écrit :
> Thanks for answering
>
> Yes, you are right. This is a client-side file. However, our concern is
> that we have to consider this practice as a security issue. We'd like to
> ban this practice for our product which is, thus, wrapping PostgresQL
> eng
Christophe Dore wrote:
Thanks for answering
Yes, you are right. This is a client-side file. However, our concern is
that we have to consider this practice as a security issue. We'd like to
ban this practice for our product which is, thus, wrapping PostgresQL
engine. Thus my questions
- is there
On 1 Apr 2010, at 9:52, dipti shah wrote:
> Yah...that's correct but I am wondering if someone out there knows work
> around to this.
>
> I could make my table owner to postgres user but then is there any way
> original user can drop the table. I want original users should allow to drop
> thei
Maybe I'm missing something, but I see 5 responses from 2 of our
engineers over the last 2 days on that thread, all asking valid
questions and trying to figure out why this is failing for you, when
it does not for the vast majority of other users. I appreciate that
you do not want to do a manual
If you really want to help and make the installer a better experience, i
asked for helping me out debug the issue
"Run the initcluster.vbs and let us know at what line number you are
getting the 'Object Required' error message".
But all you replied was : - " I need step by step procedure to ins
On Thu, Apr 1, 2010 at 10:35 AM, Nikhil G. Daddikar wrote:
> It is not the count that matters. It is the quality. Even after giving logs,
> your folks are unable to figure out the problem.
No, because clearly it is not a simple issue.
> I am facing the same
> problem that was faced by a lot of u
2010/4/1 Thom Brown :
> On 1 April 2010 09:13, Dave Page wrote:
>>
>> Following a great deal of discussion, I'm pleased to announce that the
>> PostgreSQL Core team has decided that the major theme for the 9.1
>> release, due in 2011, will be 'NoSQL'.
>>
>> There is a growing trend towards NoSQL d
On 1 Apr 2010, at 10:47, Sylvain Lara wrote:
> De : jose javier parra sanchez
> Cc : pgsql-general@postgresql.org
> Envoyé le : Jeu 1 avril 2010, 9 h 26 min 27 s
> Objet : Re: Re : Re : Re : [GENERAL] Select in temporary table
>
> Not sure about how de C# driver you use to connect, but if you hav
2010/4/1 Christophe Dore :
>
> - is there any configuration that can be done on server side to prevent
> the client side to use such file to read passwords ?
No. It happens before the user ha slogged in, obviously.
> - is there any options that can be set in postgres libpq C library to
> prevent
2010/4/1 Craig Ringer :
>> instead of %ProgramFile%. I bet half of the problems would go away if
>> the installer refused to put the data directory into c:\Program Files.
>
> Yep - it's not a clever place to put it.
IIRC, that was modeled on where Microsofts own SQL Server put it's
data files by d
On Thu, Apr 1, 2010 at 10:50 AM, Magnus Hagander wrote:
> 2010/4/1 Craig Ringer :
>>> instead of %ProgramFile%. I bet half of the problems would go away if
>>> the installer refused to put the data directory into c:\Program Files.
>>
>> Yep - it's not a clever place to put it.
>
> IIRC, that was m
Magnus Hagander, 01.04.2010 11:50:
2010/4/1 Craig Ringer:
instead of %ProgramFile%. I bet half of the problems would go away if
the installer refused to put the data directory into c:\Program Files.
Yep - it's not a clever place to put it.
IIRC, that was modeled on where Microsofts own SQL S
Dear list,
I have some data (big size) and I've written a long function in pl/pgsql
which processes the data in several steps. At a test run my function
aborted because of memory exhaustion. My guess is, that everything what
happens during the function transaction is stored in the memory - until
i
a) you can't explicitly control transactions in plpgsql. If you need some
sort of a form of it, use save points.
b) you are trying to outsmart database software, and this is just a biiig
mistake, and you should stop doing that completely.
2010/4/1 Birgit Laggner :
> Dear list,
>
> I have some data (big size) and I've written a long function in pl/pgsql
> which processes the data in several steps. At a test run my function
> aborted because of memory exhaustion. My guess is, that everything what
> happens during the function transact
Folks,
I received a call from EnterpriseDB trying to understand what the
problem is. We are scheduled to meet on Monday. I will post the findings
as soon as I have something concrete.
Thank you all.
-n.
Unless you are prepared to help us understand exactly what is unique
about your systems
Hi Grzegorz,
sorry, but that doesn't help me, perhaps you could get a little bit clearer:
@a) Does the use of SAVEPOINT avoid memory overflow? I could not find an
explanation about memory use in the documentation of SAVEPOINT.
@b) Do you mean I should not process my data or I should not use plpg
2010/4/1 Birgit Laggner
> Hi Grzegorz,
>
> sorry, but that doesn't help me, perhaps you could get a little bit
> clearer:
>
> @a) Does the use of SAVEPOINT avoid memory overflow? I could not find an
> explanation about memory use in the documentation of SAVEPOINT.
>
> transactions don't really us
On 1 Apr 2010, at 11:21, Christophe Dore wrote:
> Thanks for answering
>
> Yes, you are right. This is a client-side file. However, our concern is
> that we have to consider this practice as a security issue. We'd like to
> ban this practice for our product which is, thus, wrapping PostgresQL
> e
I have a DB (mydb) where one table (mytbl) contains a large object
column. The contents are managed by contrib/lo. This breaks when I
want to copy the DB to another host where the schema is already
present with some old contents: when I do
pg_dump -c mydb | psql -q -h otherhost mydb -f -
pg_
> It is not the count that matters. It is the quality. Even after giving logs,
> your folks are unable to figure out the problem. I am facing the same
> problem that was faced by a lot of users on the forum and not one was
> resolved successfully. Otherwise I would've moved ahead on my own. I am
>
On Thu, Apr 1, 2010 at 12:15 PM, Peter Geoghegan
wrote:
> I think that the EDB one click installer for windows is a great piece
> of software, and I'm very grateful to Dave and the EDB people for
> maintaining it, as well as the stack builder that it comes with.
Thank you Peter - we appreciate th
On this first day of the month, I thought it might be interesting
to re-visit the conventional wisdom about postgres vs mysql.
Do these seem like fair observations?
Storage engines - Advantage Postgres for having far more available.
Postgre has such a wide range of storage engines to choose fr
On 1 Apr 2010, at 12:22, Birgit Laggner wrote:
> Dear list,
>
> I have some data (big size) and I've written a long function in pl/pgsql
> which processes the data in several steps. At a test run my function
> aborted because of memory exhaustion. My guess is, that everything what
> happens durin
Peter,
Are you sure about that? Have you actually tested that? Even if you
find that the old 8.3 pginstaller works where the EDB installer
failed, that doesn't actually demonstrate that pginstaller is
inherently superior to the EDB installer. It is likely due to a fluke.
Perhaps it is down to so
On Thu, Apr 1, 2010 at 12:35 PM, Nikhil G. Daddikar wrote:
> All I am saying is that the folks check out what the diff between EDB and
> the "old" installer is without jumping to conclusions about APPDATA or
> whatever because the old installer worked. Maybe it is a fluke but isn't it
> worth inv
On Thu, Apr 1, 2010 at 12:40 PM, Massa, Harald Armin wrote:
> Dave,
>>
>> >
>> > IIRC, that was modeled on where Microsofts own SQL Server put it's
>> > data files by default. Does anybody know if that has changed recently?
>>
>> It hasn't. I checked 2008 this morning.
>>
>
> And how does SQL Serv
Hello all, this is not a joke. Does anyione know if PgCluster as a project is
suspended, or is alive and kicking. In the second case, has anyone got a medium
sized system working well with this multi-master replication option.?
Hope to hear soon.
Mike Stanton Santiago, Chile
On 1 April 2010 12:21, Ron Mayer wrote:
>
> Broad Developer base - Advantage MySQL for having a more distributed team.
>
> Postgres developers seem to be concentrated in a handful of companies.
> After various acquisitions, MySQL developers are scattered to the four
> winds.
>
You mean Enterpr
Dave,
> >
> > IIRC, that was modeled on where Microsofts own SQL Server put it's
> > data files by default. Does anybody know if that has changed recently?
>
> It hasn't. I checked 2008 this morning.
>
>
And how does SQL Server fiddle that with Windows 7? My experience is that W7
is "not amused" w
On 1 April 2010 13:57, mike stanton wrote:
> Hello all, this is not a joke. Does anyione know if PgCluster as a
> project is suspended, or is alive and kicking. In the second case, has
> anyone got a medium sized system working well with this multi-master
> replication option.?
>
> Hope to hear
Hi Alban,
thanks for your detailed answer!
My database settings:
max connections: 20
work_mem: 100MB
shared buffers: 12000MB
Server memory:
physical 32GB
total memory 50GB (incl. swap)
shared memory ??
I am not sure if I use deferred constraints - the only constraints I use
in the function are
Without asking for any blood letting, I'm wondering if there are any hard
statistics available to prove if Windows Server is faster than, slower
than or the same as for performance to one of the various Linux
distributions. While our application is a commerical application, in our
survey we've b
I just summarized some of the discussion on this thread and created a
wiki page that starts to cover each of the three tools now available for
this job: http://wiki.postgresql.org/wiki/Statement_Playback
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g..
Faheem Mitha wrote:
> Regardless, you don't address why the email I sent disappeared into
> the ether. If it was rejected due to excessive length, then it would
> be polite to get an automated rejection. Perhaps something like
>
> "Your message is too long and so is being rejected. Messages to th
Josh Kupershmidt writes:
> The solution for me was simply to run pg_stat_reset(), and the problem
> went away within a few seconds. The $PGDATA/global/pgstat.stat file
> was 1.2GB before the reset, and went down to ~250KB after the reset.
> It looks like this file is adding on 4MB or so per day at
On 1 Apr 2010, at 14:38, Birgit Laggner wrote:
> Hi Alban,
>
> thanks for your detailed answer!
>
> My database settings:
> max connections: 20
> work_mem: 100MB
> shared buffers: 12000MB
>
> Server memory:
> physical 32GB
> total memory 50GB (incl. swap)
> shared memory ??
Ok, so max work_mem
> Following a great deal of discussion, I'm pleased to announce that the
> PostgreSQL Core team has decided that the major theme for the 9.1
> release, due in 2011, will be 'NoSQL'.
>
Please, provide me your address so I can forward you the "health care"
bills I had to pay due to the heart attack
Hi Chaps,
Just noticed on the wikipedia page under rdbms, it lists postgresql as
available on AmigaOS.
http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems
Is this just an error, as I see edb advanced server is also listed as
available, or was there some working co
On Apr 1, 2010, at 3:01 AM, Magnus Hagander wrote:
>> I prefer to dump all my data in a big text file and grep it for the
>> information I need.
>
> As long as you implement your own grep, that sounds about on par with
> the current trends! Go for it!
Well, first you have to implement your own
Hello,
I am looking to implemented a master-master replication solution
for an Internet Provider company using PostgreSQL. I am looking at
RubyRep, but wanted to know if any of you are really using the product
in production and could share any pros/cons? Or is there another
solution I sho
2010/4/1 :
>> Following a great deal of discussion, I'm pleased to announce that the
>> PostgreSQL Core team has decided that the major theme for the 9.1
>> release, due in 2011, will be 'NoSQL'.
>>
>
> Please, provide me your address so I can forward you the "health care"
> bills I had to pay due
This is of interest to me, because something similar happens on the
Mac (with the one-click installer).
The data directory is placed in a file that user 'postgres' has
permission on. Of course, this is a new user, created by postgres,
but what it ends up meaning is that I run all my postgr
On Thu, Apr 1, 2010 at 10:05 AM, David E. Wheeler wrote:
> On Apr 1, 2010, at 3:01 AM, Magnus Hagander wrote:
>
>>> I prefer to dump all my data in a big text file and grep it for the
>>> information I need.
>>
>> As long as you implement your own grep, that sounds about on par with
>> the curren
Glyn Astill writes:
> Just noticed on the wikipedia page under rdbms, it lists postgresql as
> available on AmigaOS.
> http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems
> Is this just an error, as I see edb advanced server is also listed as
> available, or was t
On Thu, 2010-04-01 at 10:54 -0600, Scott Marlowe wrote:
> On Thu, Apr 1, 2010 at 10:05 AM, David E. Wheeler
> wrote:
> > On Apr 1, 2010, at 3:01 AM, Magnus Hagander wrote:
> >
> >>> I prefer to dump all my data in a big text file and grep it for the
> >>> information I need.
> >>
> >> As long as
On 04/01/2010 09:54 AM, Scott Marlowe wrote:
On Thu, Apr 1, 2010 at 10:05 AM, David E. Wheeler wrote:
On Apr 1, 2010, at 3:01 AM, Magnus Hagander wrote:
I prefer to dump all my data in a big text file and grep it for the information
I need.
As long as you implement your own grep, that soun
Could it be that pg_ctl uses some sort of unix cmd like ps to try to
determine with the postgres processes are running? Using ps from a windows
command prompt does not show the postgres processes started as services.
Mark
On Mon, Mar 29, 2010 at 1:54 PM, Mark Vantzelfde wrote:
> Same result.
>
>
Hi,
Is anyone using Lifekeeper for Linux availability with Postgres?
If so, what are your thoughts on it? Work as advertised? Any dangerous
gotchas?
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
Hello all,
I am currently adding array value handling to the PostgreSQL interface
for the Chicken Scheme compiler[*] and I was wondering if there's a more
detailed documentation for the exact syntax of arrays than the short
natural language explanation in the manual.
There doesn't appear to be a
> Hm. It sounds like you are "leaking" stats collector table entries for
> some reason. It would be good to fix the underlying problem rather than
> just resign yourself to a manual workaround. Is there anything unusual
> about your workload that might trigger this?
Don't think the database set
Josh Kupershmidt writes:
>> Hm. It sounds like you are "leaking" stats collector table entries for
>> some reason. It would be good to fix the underlying problem rather than
>> just resign yourself to a manual workaround. Is there anything unusual
>> about your workload that might trigger this?
On Thu, Apr 1, 2010 at 6:22 AM, Birgit Laggner
wrote:
> Dear list,
>
> I have some data (big size) and I've written a long function in pl/pgsql
> which processes the data in several steps. At a test run my function
> aborted because of memory exhaustion. My guess is, that everything what
> happens
Peter Bex writes:
> I am currently adding array value handling to the PostgreSQL interface
> for the Chicken Scheme compiler[*] and I was wondering if there's a more
> detailed documentation for the exact syntax of arrays than the short
> natural language explanation in the manual.
There is not,
I want to create a temp table in a trigger... but this must be created max
once for each transaction. I'd like to check in the trigger if the table
exists.
How can I check if a table is a temporary table?
regards
Szymon Guz
On Thu, Apr 01, 2010 at 04:37:23PM -0400, Tom Lane wrote:
> There is not, but you could always look at the source for array_out and
> array_in if you want definitive answers ;-). Personally what I'd do is
> always double-quote each non-null array element; then the rules reduce
> to "backslash any
On Thu, Apr 1, 2010 at 4:22 PM, Tom Lane wrote:
> Do you have a copy of the 1.2GB file and would you be willing to send me
> it if so? There shouldn't be any especially private info in there, just
> table OIDs and access counts. (1.2GB would be a lot of data to mail but
> I bet it gzips down to
--- On Thu, 1/4/10, Tom Lane wrote:
> > Just noticed on the wikipedia page under rdbms, it
> lists postgresql as available on AmigaOS.
>
> > http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems
>
> > Is this just an error, as I see edb advanced server is
> also list
Glyn Astill writes:
> But I do remember there was a set of libs called ixemul
> (http://aminet.net/package/dev/gg/ixemul-bin) that a lot of people used to
> port unix apps to the Amiga with, probably not enough to port postgres though.
Ah, I wondered if there might not be such a thing. However
A crude way would be to put it in a block and ignore the exception
BEGIN
-- create temp table
EXCEPTION
WHEN DUPLICATE_TABLE THEN
-- Table already exists,
NULL;
END;
thx
- Amol
Szymon Guz wrote:
I want to create a temp table in a trigger... but this mu
--- On Thu, 1/4/10, Tom Lane wrote:
> > But I do remember there was a set of libs called
> ixemul (http://aminet.net/package/dev/gg/ixemul-bin) that a lot
> of people used to port unix apps to the Amiga with, probably
> not enough to port postgres though.
>
> Ah, I wondered if there might not be
I have had a development environment set up in Windows for Django.
Recently I moved all my python/django setup to cygwin because I got
tired of the windows command line.
Everything seems to be working except the PostgreSQL connection. I
understand that I can install postgres inside of cygwin and a
You can see that python is trying to connect to postgres via unix
socket. In cygwin that's rather not possible.
Just switch the client to TCP mode. There should be host/port in
connection settings.
2010/4/1, nerdydork :
> I have had a development environment set up in Windows for Django.
> Recen
Hi,
I'm trying to port some source code to Postgres 8.3.8 and have been
encountering some surprises :-(
I would like to set up a column constraint for an integer type, so that when
the value is undefined, it would assign a default value of 0 to that column.
How would I do that in 8.3.8? Please
Wang, Mary Y wrote:
Hi,
I'm trying to port some source code to Postgres 8.3.8 and have been
encountering some surprises :-(
I would like to set up a column constraint for an integer type, so that when
the value is undefined, it would assign a default value of 0 to that column.
How would I do
On 1/04/2010 3:19 PM, Nikhil G. Daddikar wrote:
On 01-04-2010 12:39, Thomas Kellerer wrote:
Nikhil G. Daddikar, 01.04.2010 08:04:
In about 30 seconds I found the following unanswered threads relating to
installation on Windows Vista. If anybody is interested I can find more.
The problem w
On 1/04/2010 5:35 PM, Nikhil G. Daddikar wrote:
It is not the count that matters. It is the quality. Even after giving
logs, your folks are unable to figure out the problem. I am facing the
same problem that was faced by a lot of users on the forum and not one
was resolved successfully. Otherwis
I will bet a bucket of day-old squid that this is a user rights problem.
On Apr 2, 2010, at 6:43 AM, Craig Ringer wrote:
I log in as an Administrator-enabled user, but have UAC turned on.
This means that in fact I'm using non-admin rights unless/until I
accept a UAC prompt.
--
Sent via pg
The 8.4.2 documentation says:
"The default user name is your Unix user name, as is the default
database name."
Not so much. My one-click installer creates a user 'postgres' who
becomes the default user name...as well as the owner of the data file.
Is postgres arguing with itself here? Or
John Gage wrote:
The 8.4.2 documentation says:
"The default user name is your Unix user name, as is the default
database name."
when you as a user connect to the database server the commands like
psql, pg_dump, etc all use your unix username as the default for the
database username, and you
93 matches
Mail list logo
