Re: [GENERAL] Starting a cluster as a service

[Thomas Boussekey]

Hello Léa,

Command line, message and commands are missing.
Difficult to help you!

Regards,
Thomas

2012/6/15 Léa Massiot 

> Hello and thank you for reading my post.
>
> My problem is that I do not manage to start a PostgreSQL cluster as a
> Windows service.
> The OS is WinXP.
>
> - I've created a PostgreSQL cluster "a_pgcluster" with the associated port
> 5433.
> - Running "cmd.exe" under Windows as "a_user", I can start and stop it
> manually in command line using the following commands:
>
> - The cluster data directory is "a_pgcluster". Its (filesystem) owner is
> "a_user" with this user having "full control" on it.
>
> - Now, I would like it to be run automatically at machine startup as a
> service.
> - So I registered the cluster using the following command:
>
> - When I go to "Control Panel" -> Administrative Tools" -> "Services" and
> try to start the service, I get the following message:
>
> - I also tried the following commands in command-line:
>
>
> Can you help me try to figure out what's wrong?
> Best regards.
> --
> OS: WinXP Pro SP3
> DBMS: PostgreSQL v.9.1
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/Starting-a-cluster-as-a-service-tp5712728.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Re: [GENERAL] Data sets for download

[Thomas Boussekey]

Hi,

I'm using Dell DVD store for training purposes, and I met some problems
with it!
Once they are corrected it works well (except the load test config on my
environment, problem encountered with a RSA fingerprint!)

The following slideshow tracks down the problems:
http://jkshah.blogspot.fr/2012/09/pgopen-2012-dvdstore-benchmark-and.html

Have fun,


-- Thomas BOUSSEKEY


2012/10/25 Jayadevan M 

> >Have a look a Benerator. It can create quite reasonable test data (e.g.
> valid
> >addresses, "real" looking names and so on).
> >
> >It has a bit steep learning curve, but I'm quite happy with the results
> >http://databene.org/databene-benerator
> >
> >
> >Another option might be the Dell DVD Store Loadtest:
> >http://linux.dell.com/dvdstore/
> >
> >It can generate testdata with a specific scale and it works well with
> Postgres.
> >
> Thank you. Will try these.
> Regards,
> Jayadevan
>
>
>
> DISCLAIMER:   "The information in this e-mail and any attachment is
> intended only for the person to whom it is addressed and may contain
> confidential and/or privileged material. If you have received this e-mail
> in error, kindly contact the sender and destroy all copies of the original
> communication. IBS makes no warranty, express or implied, nor guarantees
> the accuracy, adequacy or completeness of the information contained in this
> email or any attachment and is not liable for any errors, defects,
> omissions, viruses or for resultant loss or damage, if any, direct or
> indirect."
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>